I don't self-host Wordpress, my blog is a static site made with Jekyll and served by Nginx. A static site ages well.
That said I self-host other services, like Matomo or FreshRSS (also PHP apps that need a database).
The secret is in setting up auto-update policies. All the self-hosted services I host are in Docker and auto-updated [1] even if that means they can break.
Have been doing this for some time and worked great thus far, but granted self-hosting stuff is a continued investment, you can't just leave that server there to bit rot.
That said I self-host other services, like Matomo or FreshRSS (also PHP apps that need a database).
The secret is in setting up auto-update policies. All the self-hosted services I host are in Docker and auto-updated [1] even if that means they can break.
Have been doing this for some time and worked great thus far, but granted self-hosting stuff is a continued investment, you can't just leave that server there to bit rot.
[1] https://github.com/containrrr/watchtower