Never really been to into video games but I think it may be that time. I am working a 40 hour cubicle job and have little hours of the day to do anything, so I figured why not try to zone out with video games? I am not experienced with any game console, so anything goes? Also, what games should I get?
Depends. What kind of gamer do you think you will be? Do you want something challenging and more serious, or entertainment/casual games? I would suggest (and I hate saying this) that you get a Wii. There's a variety of casual games, as well as some "hardcore" games. Rockband and Guitar Hero and great games for playing with a couple different people, and if you've been working a 40 hour a week job, this might help you destress a bit. Then again, Guitar Hero can get pretty frustrating.

Also DDR and Mario Kart are great.
There are also great games like Mad World, Super Smash Bros Brawl, and Super Mario Galaxy if you think you want something that will consume a bit mroe of your time. I don't know how much time you'll have, so you might want to stay away from RPG type games, as they tend to be addicting and very time consuming.
If you are into guns, and war games, I would suggest getting the XBox 360. It has plenty of shooters, and might help you to release some of the pent up stress from work.

Games like Gears of War, Halo (i hate Halo, but everyone else seems to love it), Bioshock(not really a shooter, but tons of fun) and others that I can't seem to remember. (I don't play my 360 a lot). The best part about the 360 in my opinion, is the downloadable puzzle game Braid. I can't get enough of it. It's absolutely beautiful. The 360 also has Castle Crashers I believe, and that game is great too. There are some casual games as well, but I'm not very familiar with them.
But, my personal favorite is the PS3. I love everything about it. The downloadable games are phenomenal. I play Pixle Junk Monsters (a tower strategy game) and Pixle Junk Eden more than I play some full games. I love Cuboid as well. But the best thing about the PS3, and probably a game you could have a ton of fun with, is Little Big Planet. It's revolutionary. Also, the ps3 has Bioshock, but also Killzone, Resistance, and Unreal Tournament (the 360 also has it) for your shooter fancy. I think the ps3 puts out better games yearly than the 360.
Alright, sorry for the rant. My suggestion: do some research. Look at some of the pros and cons of each console before you buy. Then again, if you have a lot of money, buy 'em all! Look at games featured, and decide which one would be right for you. IGN and Gamespot are great websites for research. They do articles about the differences between consoles, as well as write great reviews of games. Hope this helps..