Yeah its not a panacea. IMO there is no full turnkey solution that doesnt involve cobbling multiple services together (ie jellyfin, seer, etc). Then you have high cloud prices that, in order to save money, would require a local setup with old hardware to be cost effective.
You shouldnt be spinning up cloud resources to host your media stack. You should be buying used hardware off cycle and cobbling it together. All of which costs time to operationalize it, ie tweaking gpu drivers on linux to get that old hardware working.
It only really makes sense if youre a real enthusiast, or amortize it across your family, friends, etc. But then youre breaking a bunch more laws and as a working professional that just isnt worth the liability for the value provided.
The real answer I think is simply to consume less content.