I once worked for VC backed start-up, I've not been VC backed myself, but I worked for Australia's science and technology research agency, so let's somewhat consider what I worked on was funded, cutting-edge development. Normally too early for VC, and often very shiny thing, or polishing things expected to be shiny in the future.
I've only once worked on main street when I was managing the app for a pizza chain.
One day, sitting in a quarterly planning meeting for the pizza company, they were discussing changes they could make to the app and the comment that stood out in my head was "we forecast this change could help us sell x% more garlic bread".
In my head I thought, "I don't care how much garlic bread we sell...this is not why I'm on the planet".
I know not every mains st. business is selling pizza, and lots of B2B companies, VC backed or not, would not excite me.
You're right, helping investors make money isn't very compelling, and I think B2B, has that kind of focus, but many ventures aren't B2B SaaS.
There is lots going on in health, energy, space, etc. right now. I do expect many of these bubbles will pop, but is there something there that interests you?
I didn't see a contact in your profile, but I'm the founder off https://affectablesleep.com, we're not hiring a GTM person, but I'm currently reaching out to a few people for advice. Drop me a line if you're interested in chatting, and maybe I can help you find your next thing too.