What system you should get pretty much depends entirely on what you want out of it. You should check out the games available for the current systems before you settle on which to buy. Some individual games are produced for all of the different consoles, while some individual games are made only for one console or another.
The Wii system games are, for the most part, *very* different from the games on PS3 and Xbox360. They are most often geared towards children, which is great if that's really all you want it for. Though a few popular older audience titles are available on Wii, you can find more older child and adult oriented titles on the 360 and the PS3.
If it's the motion controlling part of the Wii that attracts you, the Xbox 360 now has the kinect, which is supposed to be an even better version of the "body as a controller" than Wii is, as it doesn't require a hand held controller at all, it watches your motions with a camera, and applies it directly to the games. Also, a good portion of these Kinect games are family/child friendly, so if you were to go the Xbox360 w/Kinect route, you'd have both regular handheld controller console play, "body as" controller play (without having to hang onto a device like you do with a Wii), and a vast assortment of titles to please literally ANY gaming tastes.
PS3 has no motion technology at all, but does have the bluray bonus. It also has pretty close to as much variety in games as the Xbox360 does, and allows you do stream movies and tv from multiple sources.
Both the 360 and the PS3 have online comunities accesible through the console where you can download additional content for games you already own, download playable demos of games, download full games, and interact with other players around the world while playing a vast assortment of multiplayer games, both in game, and verbally through a headset.
I'm *pretty* sure Wii does not have these features.
As far as getting games...the very best way to get games (and movies, and books, and pretty much anything else ever) is
www.amazon.com. Their buy used option can get you some really great deals. Otherwise, GameStop has shops in almost every mall and shopping center in America, and they sell games new and used, as well as trade games. Theay are not the *best* prices around...
amazon usually has the real deals.
Best Buy is almost *always* overpriced (even their sale stuff) , as is Wal Mart, though their sale prices are sometimes pretty good, rarely do any even semi decent games drop to a reasonable price.