1. For RH there is RHEL (RH Enterprise Linux), which is recommended for prod server. Its not bleeding edge, but very stable/reliable. Updates/patches continue for 5 yrs after initial release of each version.
You have to pay for this & the phone/email support that comes with it.
2. If you want a free but unsupported version of RHEL, use CENTOS. Same code, no RH logo. Same lifecycle.
3. RH Fedora is a free bleeding edge distro deliberately. Approx new ver every 12 mths(?). Only 2 versions at any one time are 'supported' ie have active repos with updates. Currently that's v 8 & 9.
4. Other distros have 1 or more variations of the above available. See www.distrowatch.com
5. 'Real benefit of upgrades' is not getting broken into & fixing bugs that stop you getting stuff done. IOW, the usual SW issues.