I have a vintage Pinbot (1986), and while I don't play it much, visitors - especially kids, love it. I'd like to have another one, and if I do get one, it would probably be a new/recent machine. Unless I can get a good deal on a Black Knight 2000...
The appeal is the novelty vs. video games - I think most folks would play a pinball machine regardless of the "game" itself, whereas a classic video game will evoke a "meh" from folks that don't / didn't like that game. Any pinball machine is fun for at least a few games!
But yeah, these antiques are just that - if you don't have any nostalgic reasons for buying an old machine, I would highly recommend getting a new one - or at least, a <10 yr old used one. While basic parts are readily available - the big stuff can be a challenge to find. I've been lucky with no major failures, and I just rebuilt the flippers myself (which wasn't as hard as I expected it to be). I also have a local pinball dealer if I really ran into trouble.
The new machines are very much expected to go into private use, not businesses, and if you buy a used one, getting one that hasn't been through the rough handling of a commercial machine would be highly preferable.
Play any machine before you buy it. New one you must play first to know whether or not you actually like the game or not (there are certainly "bad" games), although reading some reviews on pinball forums may get you enough info to decide. But a used machine must be exercised to make sure it's in good working order. Don't buy used machines on eBay / sight-unseen / etc.as an "amateur" pinball customer - it's very easy to make a machine look pretty for photos - and still be a POS...
Note that Stern is the only pinball maker left - so "limited edition" games are really just "how many we expect to sell".
If you haven't seen the Discovery channel stuff on the Stern factory - take a look, it's very cool to watch. And you'll be surprised at how much there is under that playfield!