Each version of Fedora is supported for 14 months, so you can keep it a little behind but still get updates. They also will update the kernel so you’re getting updated hardware new support. With flatpak having up to date desktop applications is not an issue either. For development libraries I’m usually in some kind of a container with a fixed version, so updates shouldn’t much of an issue either.
For example I just installed Fedora 35, I will probably install 36 at some point after 37 comes out, and stay one release behind current. Major upgrades are still relatively safe because of FS snapshots. I just personally prefer a slightly slower pace than “bleeding edge all the time”.
For a server I would just put Alma/Rocky Linux on it.