If your wanting to take any kind of meaningful pictures like the types you mentioned, your going to want to stay away from a standard p-a-s.

A good camera to jump into the game with is a Nikon brand DSLR. I'm not saying Nikon > Canon, but with a Nikon, things are a lot more user friendly for first time/novice photographers.