I could be totally wrong about this, but I think some Super Famicom RPGs switched into a high resolution for the text boxes so the fonts could be more detailed.
Ahhh ... I wasn't quite specific-enough. I'm only asking about the PCE.
Resolution-switching mid-screen is a "hardware" issue. Some systems are definitely designed for it (I did it on the Amstrad CPC in all my games, but that was a color-depth-vs-resolution switch, and not a different-clock-signal switch).
I can't remember if the capability was built-in to the SNES ... but I wouldn't be at-all-surprised.
With the way that the PCE splits the TV's timing between the VCE and the VDC, with multiple registers controlling different aspects of the signal, and with the VDC tending to only update certain settings at the start of a vblank, then I'm not-at-all-sure if it can handle a mid-screen resolution change ... which is effectively what Touko is trying to do with his 10MHz-in-vblank trick.
But I've not done any experiments ... so I wonder if anyone knows of a PCE game that does it, because that would be instant-proof that it's capable.