I don't watch much TV and the shows I watch don't have game ads in them but I did see most of the "Wii would like to play" commercials on YouTube and they're really effective for the target audience.
I saw an XBox ad last Christmas with mutiple gameplay footage from different games and thought it did well in making you want the system.
As for Sony, I only saw the weird ads from launch. I still don't get how a scary-eerie baby was supposed to sell consoles.
Signature goes here!