To play devil's advocate, the apps being simple to the point of pain for power users is almost the point of the distro. If you want a distro that you can wrangle into exactly what your vision is, you'll love arch. If you want the simplest possible mostly-functional option where you don't need to change anything to get it to work, elementary isn't too bad. That said I hate using it and generally dislike their entire philosophy of taking an open program, stripping out three quarters of the code, and then calling it their own and begging for money to keep doing that. Feels gross.

None of the issues you mentioned are really fixable. Online streaming is a bit of a pipe dream for linux, legal(ish?) solutions are going to be hacky and break constantly since nobody has the negotiating power to work out deals with labels. Same with videos, alphabet is not going to just allow random apps to bypass the entire point of youtube (serving ads to eyeballs and tracking said eyeballs to serve more ads). Maps does suck, and that's mostly and openstreetmap issue. You could integrate google maps but those API keys are not cheap.