I think most of us have a good idea of the benefits and drawbacks of Linux/Windows/Apple.
I have a Windows machine for media production, because Linux doesn’t support all the software I need for media production. I use Linux for absolutely everything else, because it’s better for literally everything else. In truth, a MacBook Pro would be better for media production but they’re too expensive.
By “self hosting” do you mean serving apps from your own computer, where that computer is always online so you can access your own apps from the net on a client machine? Even when you’re at work or out in the city?