If you pick a game that isn't too power hungry and the card isn't throttling on power, then assuming the temps are fine it'll simply run the best voltage it can and whatever clockspeed matches that voltage on the v/mhz curve (you can open this curve in Afterburner to see).
I'd guess that most of the YT videos involve games that aren't hard throttling much, leading to much more stable clockspeeds. Could you provide some links to examples?
Of course, if these gamers are more in the enthusiast crowd or have an interest in it, they may have a stable clockspeed because they've limited the conditions that cause the cards to bounce around. For example, my 3090 FE will generally run a fairly flat 2220-2250mhz because it's always running VRel/VOP, i.e. 1.1v. Temperature is handled by my watercooling and power by hard-modding the pcb, thereby eliminated the card's tendency to reduce voltage to external conditions, since those conditions don't exist anymore.
As regards your card, you should see the clocks flatten out a little bit by max'ing the power sliders since the need to throttle voltage in response to power draw will be less extreme. We just have to be careful not to push too hard since the memory is very hot there. Power and core offset will only affect the core, though, not the VRAM (I wouldn't recommend overclocking the memory given the temperature).