@PinkLipstick,
If your kids are very young Wii is the way to go.
For older kids (8+) a PS3 is a better bet. They have lots of fun "adventure" type games.
Portal is my favorite game ever.
Little Big Planet is fabulous! (Very good for little kids)
Toy Story 3 is really fun
Plants v. Zombies
Rayman
Ratchet and Clank (the old PS2 games are the best ones - make sure you get them remastered for PS3)
Sly Cooper (especially #2 (also remastered for PS3))
Spyro (maybe remastered for PS3)
You can also get the old Sega games for PS3, which are fun if you're into retro gaming.
None of those games have realistic guns. Ratchet and Clank have cartoony guns and the best weapons turn the enemies into ducks or sheep or snowmen.
X Box is the favorite of teenage boys everywhere. Shooting games and sports games are their strong point.