Fedora is not Red Hat per se, it is upstream. Red Hat is a few things in different spaces. For one is is a great source of documentation. Secondly, a sizable chunk of kernel code is developed and maintained by Red Hat. They are known for their zero down time kernel updating system among other things.

Fedora is excellent. However, it is very different than Ubuntu by design. Fedora is primarily useful for entry level users that intend on only running software that is regularly kept up to date and maintained. You will start running into problems with software that is not kept up to date. There are relatively easy tools like distrobox, toolbox, and podman that can run most software regardless. The exception to this comes with the GPU. If you are running a GPU, you're likely getting updates in Fedora with will break your older projects entirely. This is because Fedora is constantly updating the Linux kernel. Fedora is pushing out these updates constantly and looking for problems that might pop up. These issues get fixed and down stream to Red Hat to make it rock solid.

Ubuntu is based on a much longer term stability with even longer term LTS versions. This means the kernel and dependencies are frozen in time at a specific state. If you want to write some custom package that never gets broken when a dependency is updated, Ubuntu is the goto distro. You must be aware that, on Ubuntu, the native packages are largely out of date. You can add a ppa to the sources list in aptitude so that you get the latest packages, but these should be used only in special cases. If you want to be up to date, use the proper distro for the task.

This context is more important for servers where you want to deploy a project using a bunch of apps and packages. Once it is working, it should stay working for however long the LTS kernel is supported.