Dangerous opinion, I’ve recently moved to Fedora after Ubuntu and after customising it on the GNOME desktop, it’s literally Ubuntu (But better) in every way except no snaps.
Personally as someone who got the ground running using Ubuntu as my 1st Linux distro, fedora is a comfortable transfer and I really like their spins.
Sure DNF can be slow but you can fix that and sure redhat can be a little… difficult with their decisions.
What do you think of Fedora? So far I enjoy the stability combined with near-arch levels of getting new updates!
Could be I’m just lucky, but I upgraded Fedora desktop to 40 while still in beta, and never had any issues with codecs. As a matter of fact, I in every install I immediately install all codecs, as well as MS fonts, never had a single issue.