I think the main reason people are buying mac minis is because of how much user friendly it is.

You can expect a software engineer or a devops guy to run stuff in a VPS but a slightly less technical person won't ever go there. In contrast, people are familiar with macOS and that's way less scary to setup.

The added benefit of the mac mini is that it can also double down as a second device one could use for something else too