If I understand it correctly, Bluefin was just the first downstream uBlue variant like Aurora that had the various goodies built into the images. Bluefin effectively being the Gnome version of Aurora. I think it was simpler to tie the Aurora builds into the existing Bluefin pipeline for generating images and packages.
I highly recommend Aurora (dx) if it sounds like it fits the bill for what you’re looking for. After starting out with Kinoite and rebasing on Aurora-dx, the latter just feels like Kinoite with all of the desired additional packages already baked in, and some great additional shell scripts for convenience.
Rebasing sounded intimidating but it was literally just a simple shell command and a reboot. One additional command if you want to hang onto the previous image the way you had it. Rpm-ostree is pretty magical.
Can’t speak to all of your points, but the main thing I’d recommend is to try distro hopping with some of the common recommendations. If you have a spare drive that would be the easiest. Mint and PopOS are probably the first two worth trying to see how things go.
In terms of games, you should really be checking protondb for compatibility. It shows the C&C series generally looking pretty good. If you’re out of the loop, Proton is essentially an improved version of Wine that Valve maintains that’s focused on games, but it’s free for anyone to use.
For text editors, there are an insane number of options. I’ve been pretty impressed with Kate from the KDE folks. Ties in best with a KDE-based flavor of Linux, but works great everywhere. Codium is a fork of VSCode that strips out all of Microsoft’s telemetry. Also great to use and very powerful with insane flexibility through plugins.
Regarding fragmentation across distros, you’re mainly looking at RPM-based (Fedora, Suse), deb-based (Debian, Ubuntu, and a whole slew of others based on those). Most programs will be bundled up as a deb or rpm. Efforts have been made to make more platform-neutral packages for distribution like Flatpaks, Snaps, and AppImages. Those have their quirks, and people have strong opinions about their merits and weaknesses, but generally you’ll be able to get those to work on any distro without much fuss. There are some cool utilities like Distrobox which do a pretty good job of setting up containers for different distros so you can install and run their native packages.