Fedora is a very solid, no nonsense distro. It gives you a vanilla Linux experience, with sane defaults out of the box. You get major updates every 6 month shipping newer version of the core stuff (kernel, desktop environment, etc). The Fedora community is dedicated to deliver a reliable OS and tests a lot before shipping updates.

It's my favorite desktop/laptop distro for many years.

However, there are a couple a pitfalls to avoid. If you go for it, follow some beginners guide to get you sorted out with things like codecs and proprietary drivers. E.g: Things to do after installing Fedora 40 - itsfoss.com I would definitely recommend to do steps 2, 3, 4 and 5 from this guide.

I'm going to be switching to Linux before Win 10 is end of life, and there are so many more options than there were in the early 2000's.

Fedora isn't my distro of choice, but I can confirm it's an excellent no-nonsense choice. It gets the job done with minimal fuss.