I wish there would be a way to just buy sp500 minus a list of firms, so I could invest in a diversified way without going into Uber and friends (or any other firms that make profits on paper without the cash flow to back it)
Uber is cash-flow positive [1].
Due to stock-based compensation, many profitable tech firms hit this metric before GAAP. Put another way, if you owned the entire business, you could sustainably extract those profits.
[1] https://s23.q4cdn.com/407969754/files/doc_earnings/2023/q3/e...
Simplest thing would be to find an actively-managed mutual fund that focuses on what you want. (Warning: What you want is probably to lose money compared to the rest of the market.)
You can pretty trivially DIY that.
(Disclosure: The CEO is an acquaintance, but I have no financial interest.)