People who are actually doing "important" or "exciting" work I don't think have this attitude - they consider whatever they're working on to be important and exciting. I've found this to be true from executive positions at corporations making a ton of money, all the way down to flipping burgers on a grill for minimum wage. It isn't specific to software development.
If I felt I was being mistreated or forced to work unreasonable hours, that would be different story. Aside from that I really do believe that a job is largely what you make of it.
I don't think I'd be happy at a company whose own founders don't believe in their mission and are only in it for the money. Built to flip, right?
It's just the nature of the Internet, and anything related to consumer entertainment, that there are going to be some really fluffy / inane things that become ridiculously popular / valuable. As long as the folks behind them realize they're not the new Shakespeare, there's no reason to assume they're any different from people working on more mundane or serious problems.
Also, re this comment "The prevalence of social bubble-worthy companies whose value propositions are little more than "cat pictures" suggests an inflated sense of self-importance among the founders, and I can't expect to keep my level of enthusiasm in line with their irrational exuberance." ... I think you're over thinking this. There are silly startups because people (for one reason or another) are willing to invest in them, and generally those folks aren't the founders. Whatever startup you go to, you'd better believe in what they're doing, because you're going to be taking a huge financial risk and going through a lot of stress attempting to play out that belief.
If you don't believe in a startup, don't work there - but also don't denigrate whatever vision they're trying to implement, at least respect that they're trying.