I had an actual XServe rackmount YEARS ago, well I still have it but it hasn't been used in almost a decade.
For home I use an UnRaid server, it gives tons of functionality, think of it similar to Synology but more for the DIY space. Fairly small form factor case that can still hold 8-9 HDD's, etc. I just don't use Mac servers because they offer very anemic service for what I want but used to exclusively use it until about year 2 of Apple stripping the server app down to essentially nothing.
UnRaid is my Plex server, Time Machines for the Macs in the home, Windows backups for the Windows machines in the house, photo storage, various VM's to mess around with different OS's, my Homebridge server to run all the various homelink and non-homelink items in Homelink, Home Assistant, PiHole.
At the office I use 2 - TrueNAS in a rackmount, Windows server rack, a Mac Mini in a rack for one program.