You don't need component cables for Widescreen, but 99% of Xbox games, a lot of GC games, and a handful of PS2 games support progressive scan 480p.
You literally lose half of the resolution by not buying the component cables.
http://www.hdtvarcade.com/ maintains a fairly accurate list of what games support widescreen, 480p, and other 'advanced' graphics and sound.