I think by the end of the second year (2015) maybe 40 of the original venues were still running and only about 10 of the ones that started with a grant. Lots of the survivors have changed hands multiple times, and currently the most successful ones are owned by larger bars/organisations or the casino (we've only got one...). In the first year, places were closing withing WEEKS of opening even when they were full every night.
I've always been obsessed with power optimization & energy efficiency. I'm endlessly motivated to chase it, through all the drudgery and boring crap. But I have no interest in mixed drinks. I can't help but think I'd make a better home efficiency contractor than bar owner.
Locally, one of our most successful new bars was founded by a career bartender who loves the scene, the drinks, the kitsch. He & his compatriots identified & filled a nightlife niche that few could have.
You open a small business for one reason: you want to run a small business. Its work, and the satisfaction has to be in the work you'll be doing. Which includes payroll, purchasing, scheduling, negotiating, and on and on.
The OP had a good point: if you wouldn't open a dry cleaner, then don't open a coffee shop either. Nor a bar, nor a restaurant. Because you don't really want to own/run a small business. You're a romantic, and you will fail.