Peter1986C

I am not renting a VPS from them (only domain registration, an e-mailadres and whois privacy), but have you looked into the offerings from Infomaniak? Mind you, things like the TLD influence the price a lot (reg and/or renewal), and hosting related services can increase costs as well.

It has been a while that I used it, but Manjaro is Arch Linux with access to the AUR enabled by default. So it is very rolling and given the malware that has been found in the AUR more than once in 2025, I am not sure how much I would recommend Manjaro.
Myself, I am on Solus KDE (rolling, but not to the extend that Arch (derivatives) are) right now and that is pretty solid. Its disadvantage over Fedora is that you have to set up a firewall yourself, as well as the fact there is a slightly larger reliance on system packages (Flathub is still accessible from Discover).

You are correct on Fedora not being rolling. My mistake. If you are fine with not having (as many) native installs you should be fine with Fedora.

If you migrate to Fedora KDE, just remind yourself to set the checking for updates on a weekly or monthly basis to mitigate the “updates a lot” con of a rolling release. This is done in the settings app that KDE ships.
Mind you, Fedora spins with a desktop (in contrast to their server variants) primarily use Flatpaks now (either from them, from Flathub or both) so you may wish to consider whether you would mind that.

I switched to it (KDE version) earlier this year (away from Fedora) and apart from a few minor things (e.g. there was no firewall, so I installed firewalld) it has been running pretty well.