Is there room here to ask about software? I've been interested lately about getting into hosting my own server for multiple things. It'd be nice to be able to access it remotely for files for work, as a media server locally and remotely, and to access my Stable Diffusion instance remotely. I suppose those all require different solutions right? I'd love to know more!

yunohost it's basically an os that easily lets you selfhost, by having an extremely big amount of selfhosted services packaged with scripts that autonatically set everything up and all of that trough a clear and modern web interface.

Collabora Office. It's a free LibreOffice fork for iOS/iPadOs. I stumbled across it when I taught regular expressions to my pupils and only had MS Office at hand, on the school computers, which is crap at searching for pattern matches in documents. Libre Office is really good at that. And all my pupils have iPads and they could use Collabora Office.