Debian is very well suited for application servers, web servers, file servers, hypervisors (personally, we use Proxmox for some hypervisors and this is based on Debian), and much more. It can run on various CPU architectures and scales well from large to small. We have Debian DNS servers running on Raspberry Pis, and large application and database servers running on powerful Debian installs in our racks.
If you want an OS that is rock solid, easy to manage, and predictable, Debian might be the OS you're looking for. The official packages are generally far from being bleeding edge versions, but this means that you are using packages that are battle tested and will not break compatibility at any point during its life-cycle. This, to me, is one of Debian's core strengths and a good reason for recommending it to others.
On the flip-side, the lack of up-to-date versions of various packages may be an annoyance if you actually do need to be using the latest version of such a package. If you need to be using more modern versions, you will need to remedy that yourself or look at an alternative distribution. Ubuntu may be worth a look, in this case, being that it is basically Debian with newer packages and some minor differences here and there.
Personally, I would not recommend Debian for a graphical desktop OS. You'll nearly always be better off with one of the Ubuntu flavors for a modern desktop with all the bells and whistles you'd expect with a GUI desktop.