My set of recommendations:

RPMFusion is recommended to add to your system. It's the best way to use Steam, certain drivers (nvidia, v4l2loopback, etc.) as needed.

SELinux is present, but the default policy sets are unlikely to impede your usage. The SELinux applet (seapplet) is a useful tool for diagnosing on the very rare chance you're finding permission denied somewhere that cannot otherwise be explained.

If you pull most of your software as flatpaks from Flathub already, your day-to-day experience won't be much different from Debian.

Fedora's equivalent to LTS releases would be the downstream LTS releases provided by Redhat, RockyLinux, AlmaLinux, and others. They don't have the same package sets as base fedora, and may need extra repositories to get some of the less essential, but 'core' software back. Ultimately not much of a reason to run them on a desktop workstation for personal use.

Upgrading is pretty seamless. It's as easy as graphical updates now or otherwise using the system upgrade module in dnf. I generally have the policy of waiting 2-4 weeks for any minor bugs that made it into a new release to settle. I have been expediting my upgrades for the past few releases in order to catch bugs before friends and family upgrade their machines and haven't found any large problems regardless.

Fedora doesn't inherently expect a system to upgrade forever without maintenance, with 5 years being a typical target for things that may break. With that said, it is good to read the release notes before upgrading to the next edition, as there can rarely be something (like the recent recommendation and changed default for a larger /boot partition) that may require maintenance on a long-term system before upgrading. That said, you do have time to hold off on upgrading the distro, as the general lifetime of each release is ~13 months, giving 1 month overlap into a release two releases ahead. For instance, Fedora 43 will still be maintained up to a month into Fedora 45's release.

It uses DNF which has its own set of features compared to APT. In general I think DNF is much better although it does have more overhead.

You also could look into Fedora Atomic https://fedoraproject.org/atomic-desktops/kinoite/

Atomic desktops use overlays instead of packages which means you get a much cleaner system at the expense of some flexibility.

I already know that I won’t be able to use apt,

... You can. Could hijack it with Bedrock Linux, and brl fetch <any distros using apt> or import . Of, if that's too non-trivial a system change, perhaps just Distrobox? It'd let you use apt too right? (I don't know, I've never used Distrobox since I already use Bedrock). Or could go really wild, and make it like PCLinuxOS, and have apt handle your rpms. Or just alias the commands to make it familiar.

switched to fedora coming from windows and ubuntu. I update when I feel like it (every one to two weeks). It is largely rock solid and the only times i had Trouble was because of xone, which I installed via the source and then forgot to remove/update for quite a while.

dnf and apt are quite alike, took only a short while to adjust and now i like it as much if not more.

The KDE Plasma experience is very nice. I can fully recommend Fedora

Consider a Universal Blue image instead.

Chromebook easy Fedora out of the box experience. Batteries, Bells and Whistles included.

Easy peasy rollbacks and upgrades.

No more needing to manually add RPM Fusion just to get working hardware acceleration for Media in Firefox or to install Steam. Or extra steps for Nvidia drivers.

I started on Fedora KDE 32 eventually migrated to Fedora Kinoite 38 and have been a happy Bazzite enjoyer ever since. 🎮🐧🥹

Baked in #Distrobox, #Homebrew and #Bazzar Make installing and exporting .rpm or .deb files painless. Integrated Homebrew and Flatpak installers for installing apps.

And super useful and convenient #ujust commands you won't find on Fedora.

Can even Fork/Make your own Image, or checkout some Community images.

George made a Project Bluefin LTS image. Or you can also be more bleeding edge with testing branches.

Developer Experience images are also available.

Why would KDE work better on Fedora than any other distro?

I was using Fedora because someone recommended it, and the rolling release model broke stuff for me multiple times so I am no longer using it (liking release models specifically based on Debian more).