For a desktop it's suitable for 99% of what you'd want to do. Might not be the best tool for large servers or something (I really don't know) but I'm sure all that depends on use case.
I actually really like Spotify as a service. YouTube music comes free with YouTube premium and that is the simplest way to stops add on Roku. Plus, I don't mind supporting video makers.
I pay for Spotify and YouTube music. If I really like an album I'll still go to Bandcamp if I can and grab the flac files. If it's not there I'll just BitTorrent/Soulseek/yt-dlp it.
If I don't have raw media files, I don't actually own it.
If you don't like the way Steam works you can always game without steam. Heroic is a free and open source game store front end. It lets you buy games from DRM free online platforms like GOG.
It uses the same Proton compatibility software as Steam. It's a win win, you can support your favorite game publishers and have a free and open source platform.
It's weird that everyone keeps looking at this thru the eyes of capitalism. We don't need neck-break-speed feature updates, we don't need to appease our shareholders. If one platform grows on the Fediverse the others don't get "left in the dust".
We need to move AI from the cloud to our own hardware running in our homes. Free, open source, privacy focused hardware. It'll eventually be very affordable.
Running a solution like Wiregaurd + VPS or Tailscale is probably your best solution. It'll be transparent for you and won't set off any red flags for the network.
I've run tailscale on a cellular home internet platform as well a shared one like you have and it was slick.
Google search has been fundamentally broken for at least two years. When the protests started on Reddit 90% of Google's search results we're broken.