I am about to switch away from my Mac Mini Server:
It gets way to hot, more and more features are no longer available through Server.app, and Spotlight on MacOS Server has never been great (at least not better than on an up-to-date Synology NAS these days). Each update was a reason for bad sleep …
Since all the software we were using as local installations moved to SaaS, only file storage and Resilio Sync are left – band oth can be done with a NAS or cloud services like Google Team Drive / Google Drive File Stream. The latter has great reliability and many useful compliance features.