Register Hardware's local Maplin provided the HDMI-DVI connector for a very cheeky £20, while an old Sapphire graphics card review unit furnished the DVI-VGA convertor - it's a stock ATI-branded unit. The first unit's connector is DVI-D, the second one DVI-I.


Apple TV adaptors: HDMI to DVI-D (left) and DVI-I to VGA
And yes, it does work. Reconnecting the Apple TV reveals there are now only two resolutions, one of which, 576i, is ticked. Movies, photos, album covers - all are now in colour. Here's the pic to prove it:

Hurrah! Apple TV output in composite-video colour
Yes, the cable coming out of the Apple TV is the one that's feeding the TV's composite-video port.
Kudos, then, to Mauricio Pastrana for discovering this.
How does it work? The trick is clearly to fool the device into outputting in composite-video. Using the DVI-VGA converter is enough to make the Apple TV think it's connected to a real device - something that the HDMI-DVI unit alone wouldn't do. Removing the unit causes the Apple TV to fall back to the previous resolution, and that's 576i. The green component would seem to be connected to the unit's GeForce Go 7300 and ancillary signalling circuitry in such a way that it's capable of handling a composite signal too. When falling back from the 576p resolution, the Apple TV's video sub-system detects the present of a composite-video device - the TV - and adjusts itself accordingly.
The snag is that this hack doesn't survive powering down the Apple TV - plug the plug and when you restart the device, it's in black and white again. And the timing has to be exact - if you're too quick or too slow at removing the HDMI-DVI-VGA, you'll get the wrong resolution. Not to worry, though: just pull the power cable, restart the Apple TV and try again.
Update Wait until the LED on the front of the Apple TV goes a steady orange before yanking out the HDMI adaptor. It may be five seconds, it may be more. But that's the point at which the resolution is set.
But the bottom line is that Apple TV users shouldn't be forced to hackery when the gadget can support composite-video output. Yes, consumers are buying HD TVs but there are still many, many more standard-definitio screens out there, all of which can be supported by the Apple TV but are nonetheless ignored.
Heck, even if Apple offered a $30 dongle that would handle the conversion, that would still, for many buyers, be a worthwhile purchase and would certainly open up the Apple TV to a much wider audience.
Regcast training : Hyper-V 3.0, VM high availability and disaster recovery
COMMENTS
J Stiles
The reason you're mystified by all of this is because you don't realise that a) SCART/Peritel is a European notion invented by Philips and b) most CE devices are designed for the US market principally and then adapted for the rest of the world IF we're lucky. Yankee-doodlers don't use SCART - they DID use S-Video (which is why the S-Video input on so many TVs gives the best picture...) and they DO use component. Apple designs things in California, which is a subset of the USA.
We're lucky the the Apple TV isn't locked at 29.97fps from the get go.
Cameron
If you're the kind of person who wants to watch things in composite video, you're probably not the kind of person who spends £250 on a living room iPod. If, on the other hand, you're a wannabe geek who has the ambition but none of the technical know-how to save money by bodging a well designed gadget into a nightmare of adapters and hastily lashed-up wiring, then go right ahead and perform this ridiculous 'hack' (don't bother using a component - SCART RGB adapter, that might actually give you a decent picture).
Christ on a Raleigh Chopper.
@Ian K Rolfe
The point is, "component" video using the red, green and blue audio plugs *ISN'T* RGB; it's Y/R-Y/B-Y (where Y = 0.6G + 0.3R + 0.1B + S and is basically a mono composite signal). SCART uses RGB and timing.

IT infrastructure monitoring strategies
Requirements Checklist for Choosing a Cloud Backup and Recovery Service Provider
Cloud based data management
Enabling efficient data center monitoring
Agentless Backup is Not a Myth