If you want to work in a RHEL-like environment (use a similar package manager, configuration, and so on), then you could look at Fedora (Workstation edition), which is in the same branch of the Linux family tree as RHEL.
Fedora/RHEL uses RPMs to install software, so you can check in advance whether your favourite application offers an RPM. Most of the major dev tools do, including VS Code, etc.
But whichever distro you choose for your desktop OS, you can still try out other distros by running them inside a container.
Linus Torwalds says he uses Fedora.
I don't see why you would use Fedora instead of Centos / Oracle Linux / RHEL free dev subscription.
Maybe because Fedora gets the cool things first before other get them. For testing.
Fedora/RHEL uses RPMs to install software, so you can check in advance whether your favourite application offers an RPM. Most of the major dev tools do, including VS Code, etc.
But whichever distro you choose for your desktop OS, you can still try out other distros by running them inside a container.