Okay, here's an interesting take on this for those who have the time and inclination.
With some time on my hands, and clearly if you don't have loads of spare time there's no point in going through this exercise, I decided to have another go at this.
I backed up everything using CCC so that I had a bootable and easily restorable backup of Leopard 10.5.8, then set about doing a clean install of Snow Leopard (SL). Bear in mind this is not the first time I've done a clean install, but I wanted to give it one last chance.
Booted from the SL DVD and wiped the original partition, then did a clean install. I installed only everything I needed, which in my case was: nearby printers; English only; Quicktime 7.
Soon as the machine finished the install and booted into SL, I shut it down. I didn't touch any preferences or open any applications. Once the machine shut down, I did a PRAM and a SMC reset (1).
With that done I booted into SL and installed iWork and iLife, then began the process of running software update until everything was up to date. I would normally update from local downloads, but just this once decided to let Software Update handle everything.
Cool, cool, cool computer. Just to make sure, I ran YouTube in one tab, BBC iPlayer in another, and another video from a NSFW site in another. The last of the three sites has always caused problems with overheating. No such problems this time.
Ran activity monitor for a while, and noticed that even when I'd closed all the Flash video windows Flash Player (Safari Internet Plug-In), which runs as a separate (32bit) process under SL, was still running and using around 15-20% CPU. Went to the Flash Player download site and ran the version checker, noticed I was a couple of small versions behind, so update. Rebooted, just so I could run the same tests relatively clean.
Same results, machine running very, very cool. No screaming fans, no hot to touch MacBook. Here's the best part: with the latest Flash Player, when you close the last tab that had a Flash Video running, the player immediately drops the CPU, then a minute or so later it dies.
So, thus far, happy with the way SL is running here. I wouldn't recommend my methods to anyone because there's very little consistency in the way this is being reported by people and the symptoms they're reporting are variable. However, if you're bored and have the time and the kit to do it, it's only going to cost you half a day.
One final observation regarding heat on my machine. Occasionally, and I can't for the life of me imagine why or how I managed to check this, but despite my LED being green, checking the battery status tells me that I'm 99% charged, and it stays there. The fix for me is always to unplug for half an hour and plug back in, then it always recharges to 100% and the heat goes away. However, this is much less of an issue for me since I went through the somewhat convoluted process above.
If anyone can be arsed to go through the above, then I'd be interested to hear about your experiences. Perhaps even the latest Flash Player will work for you.
There is, however, still one problem: battery life is still reduced in SL, and I believe it's to do with the Flash Player running as a separate process, but the latest version has definitely improved things for me.
I never did hear back from Apple after sending them two letters, and nor do I expect to, so the next time I ask a question in these forums and one of the wags who have a nasty habit of simply posting a feedback link as a reply, they're going to cop for it.
Writing to Apple about what is clearly a serious problem for some people is pointless and it'll serve them right if this issue ends up somewhere like The Register, because it's like barking at the moon.
An acknowledgement would be nice, a commitment to track it down and fix it would be better, sheer bloody-minded ignorance isn't acceptable.
(1) I noticed something interesting when I went through this process: the instructions for doing an SMC reset were changed just over two weeks ago. When I originally checked them, there was an option there to use a keyboard combination for late 2008 MacBooks. That option has now been removed from the KB article and replaced with the original, unplug, battery-out, power on for five seconds instructions. Whether that's made a difference or not, I don't know. Whatever, everything seems to be working fine for me at the moment.