It's lowered the threshold for homelab style projects dramatically. It's not doing anything I couldn't have, but the juice wasn't worth the squeeze before compared to, say, Pikapods. Now there basically is no squeeze, just juice.
VPSes are usually compared to full-service cloud hosting and especially to serverless offerings, with proponents usually claiming that the costs of self-management of a VPS are vastly less than the premium AWS or Google charge for providing managed compute.
I’m mostly pointing to the irony of eliminating the ‘advantage’ of a VPS (that you can self-manage it like a grown-up, you don’t need a cloud provider to babysit you) by outsourcing management to a stochastic sysadmin who charges by the keypress.