What I would really like is an AMD 9800G-X3D that would be a great chip to own!
I'm afraid you'd just create problems faster than you can solve them...
First of all: aggregating functionality and performance means aggregating heat, which is less troublesome to eliminate with more surface area on spread out dies.
In a thin and light notebook you accept that and compromise on performance, but if you're aiming for better gaming muscle, the returns have a hard time justifying that effort.
And SRAM simply uses too much real-estate with 6-8 transistors per bit of cache to completely replace a frame buffer, which means you'll still need something with sufficient sustainable bandwidth and capacity.
That can be multi-channel DRAM on a shared die carrier à la Mx or Lunar Lake, it could be HBM or GDDRx, but it will also need space and cooling and there is no chance it will fit into an AM5 socket.
You'd need to question your motives: why do you want an APU?
If it's about not needing a dGPU, it's all the troubles I mentioned above.
If it's about being able to transition from a very low power environment up to great gaming with a dGPU-on-demand, you'd be paying a lot extra for iGPU transistors that won't get used in gaming.
Again on a notebook, people pay extra for that flexibilitiy.
On a desktop there will still be some interested, myself included (because it runs 24x7), but AMD is financially so much more healthy than Intel, becasue they won't do bespoke small niche designs: if it doesn't have scale, they won't go for it.