Is buying a 'vintage' frame worth it?

That depends on whether your priority is riding the bike or selling it on when you are done. If the former, then finding the best bike you can afford may be the better strategy.

I buy frames to ride them, not for the investment. I calculate there's a good chance I'll ride them to death (or my death).

well put