Some interesting commands for ME2 include being able to kill all enemies in the area you're in, as well as kill Shepard if you want to.
The in-game console works in both Mass Effect 1 and Mass Effect 2, and you can find a complete list of codes on the games' wikis ( ME1 over here, and ME2 over there).