You've got the general idea of the site down yes. But most of us here, also aren't super deep pockets and don't just buy upgrades to buy them, they've got to be a worthwhile upgrade that you can feel.
I have literally every generation of AMD components. I don't have x3d parts, no. But I do have a Ryzen 1600, 2600x, 3600, 5800x, and a 7900x. I can tell you PERSONALLY, I'm not super interested in Ryzen 9000 series, as my 7900x finally feels like enough CPU. I can tell you a jump from a 5600x to a 7600x would be a pretty bad decision, it'd be no different than a 3600x to a 5600x jump, except you're doing a whole platform.
It is my opinion, a 5700x3d or 5800x3d would be the upgrade of value choice in your situation. Tired of AM4, I totally get that. But a single CCD x3d chip on AM4 absolutely WOULD get you into current gen speeds. A 5700x3d / 5800x3d is about equal to a Ryzen 7700x ish. I would assume the Ryzen 7800x3d would be about equal to a Ryzen 9800x when they release, based on past x3d chip performance vs next gen.
If you're feeling the itch, you're going to want more cores AND more IPC to properly "feel" the upgrade. Unless you've got deep pockets to get the full fat 7950x (or 5950x on AM4), then the chip you want is the 8 core x3d chip. Your choices are either an AM4 option and keep your parts, or jump to AM5 with the 7800x3d (or go with just the more cores of the 7700x / 7800x). Or.....you can wait the ~1 month for Ryzen 9000 series to hit, and perhaps pick up an 8 core part of those. Those might also influence current part pricing.
I'd either wait for 9000 series (and look at 8 core part upgrades), or grab an AM4 x3d chip now.