I bought a VGA to Component cable converter.
Would this work to connect my Windows 7 PC to my TV (it has the standard input I use for the Wii), or do I need some kind of "smart" converter?
If the video card you have supports TV out over VGA, then yes... you can use it. From that product page...
Not every video card supports this feature. If your video card does not support TV out through VGA, then you need an actual scan converter like this to convert VGA to composite.
Ok. The computer is a Windows 7 PC. You still need to look up the product page for the specific video card that is in that computer (or integrated video chipset) in order to know if it supports TV out over VGA. That, or you need to edit your question again to supply that exact information here so we can look it up for you.
This question is protected to prevent "thanks!", "me too!", or spam answers by new users. To answer it, you must have earned at least 10 reputation on this site.