Maybe Fedora is similar to Windows in the sense that the base OS doesn't change much and is generally stable but all the software packages for the shit you actually use an OS for, so a web browser, office suite and so on, are kept up to date with their individual upstreams. Dunno, never played with Fedora much.
Funny you mention Fedora because I've sperged at length about it multiple times. TLDR: it's just "okay." Fedora is explicitly a hobbyist distro that functions as a literal testbed for Red Hat Enterprise Linux. When you use Fedora, you're using what effectively amounts to a Windows Preview every 6 months. What you see in Fedora is what Red Hat wants Linux to be like in the next 2-3 years depending on when the next RHEL release is due. Fedora tracks the latest versions of the kernel, Wayland, systemd, Mesa, etc but every release "freezes" the desktop environment. Any given release of Fedora's supported for approximately 12-13 months, so it has a fast turnover cycle. GNOME/KDE is the default, Wayland-only, but you do have options for community-built "spins" with alternative desktop environments like Cinnamon, Xfce, MATE, i3, Budgie, Cosmic, and so on.
Fedora damn sure ain't a normie distro in the slightest. Red Hat's beholden to US export law, software patents, and as a result, opts to minimise liability wherever possible. FFMPEG that ships with Fedora by default is deliberately gimped to avoid infringing on patented codecs, Fedora's version of Mesa is also gimped to avoid hardware codecs like VAAPI, VDPAU, etc. They work, but OBS will only ever stream/record in Software mode. You need to rely on
RPM Fusion to get all the software that Fedora's repos can't legally ship or otherwise refuse to ship for liability reasons.This includes FOSS tools like FFMPEG (the full version, called
ffmpeg-freeworld) and Mesa (also the full version;
mesa-freeworld) alongside FOSS tools of murkey legality like
libdvdcss,
libbluray,
libbdplus, and
libaacs. NVIDIA binary drivers are also the domain of RPM Fusion, you must manually install them and blacklist Nouveau, and that same RPM Fusion non-free repository also has stuff like Steam and
lpf-spotify-client (the Python script that converts Spotify.deb into Spotify.rpm).
If all of this sounds unappealing to any normal person, that's because all of this
is grossly unappealing to most people. You'd only ever daily drive Fedora if you own bleeding edge hardware and can't be fucked to wait 2-3 years for the next Ubuntu LTS release to show up so that the Linux Mint team can finally update their shit. Either that or if you're a complete and total simp for Red Hat and Poetterware more broadly.