Due to the advent of low power small form factor PCs/SBCs like the Pi, and all the additional management options you get these days: conventional bare-metal, but also containers, VMs, and everything in between, coupled with IaC like Ansible or Salt. A single machine can now be far more useful than just classical Unix services like LAMP or SSH - but you can still have those if you wish in addition to the new stuff!
I recommend checking the subreddits /r/selfhosted and /r/homelab to get an idea what people do these days. These are by no means the only places where all the cool discussion takes place, but they are a very good jumping off point. If you’re interested in managing file storage that goes beyond a few TB, /r/datahoarder is a good place to look too.
(And yes, running an email server still sucks. This time, the complexity is no longer about setting up or maintaining the thing (Mail in a Box/Mailcow basically put this whole thing on auto-pilot for you, including initial setup), but about fighting the major email providers to force them to not silently drop incoming messages sent from your server).
I know a NAS is not what you're asking about, but it goes give you a huge % of the features of a home server with only 5% of the effort.
Website server.
SSH server for remote logins.
I refuse to use a third-party service for these items.
All off-grid on a RPi (well two, because I'm too idle to consolidate them and save another watt at the moment)!
Mostly - for web servers, ssh and few vpn services.