Hi mortz,
Assuming you have access to stable electrical and Internet connectivity, the Pi could make a good, reliable server for a variety of functions. Obvious services like file sharing, monitoring, security, along with IT-focused capabilities like running a Gitea server and even a Kubernetes server (Rancher’s K3s and Ubuntu’s microK8s work out of the box on the Pi’s ARM-based hardware).
As for a place for interaction and inspiration (in addition to my book ), take a look at some of the projects Pi enthusiasts have posted in the Raspberry Pi reddit at:
Raspberry Pi Projects Hub (reddit.com)
Best of success with your Pi journey!