But the dream, and the reason all the coastal co's are in it, is to be the next Google or Facebook, or Twitter or Snapchat.
You could say an app to get people to come over to your house won't change the world, but people think hey maybe it will grow, or we'll just pivot, and wind up with the next Flickr or Slack, and that's certainly good enough.
Sure, but that just means that they and their competitors have already grown to the point where the market is saturated, and any further growth they are experiencing is because the market is growing or to the detriment to their competitors. They probably already had an exponential growth period, although it could have been short-lived if the market is small (and if the market is really small, may not have looked like exponential growth at all, and may have just looked like becoming profitable and leveling out).
You're right that not all niches will attract VC funded competitors, but I think the number niches that meet that criteria are actually very small, in this industry. There's always someone that thinks they can disrupt it somehow, or market it better to show people the market is actually much bigger than it appears. Keep in mind, the VC funded competitor doesn't have to succeed in it's task of taking over or changing the market to have extremely detrimental effects on companies that aren't working with the same paradigm.
Having a market large enough to support a few small companies but not large enough to warrant VC funded competitors that stays that way seems a rarity.
So, either the next Facebook or lifestyle. Of course, real world is not perfect so there's space for medium-sized businesses, but they're not an economic optimum (they're leaving money on the table either way).
There are some exceptions, but most any successful technology product needs at least a few great technical leaders, if only to say no to net-negative ideas, provide mentoring to those who need it, and to make strategic technical decisions (architecture, tech stack, technical hiring strategy, etc.).
There are highly competent people in both the lower 90% of the top 10 schools as well as in non-top tier schools
And as for competence, there's an order or two difference between a developer that can add some more CRUD to a service and one that can say no to doing the exact same thing when it is a net negative to the system and/or organization. It's one of those things that sounds simple, but it takes a lot to even know which technical battles are the top priority.
But of course that definition is useless to a VC fueled, exponentially growing trainwreck/unicorn that wants to hire hundreds or thousands of "engineers".
What if most startups only need "good" developers to develop their mostly CRUD apps and don't need "the best" developers?