I confess a personal bias for Canon.
As far as the various types, well, that pretty much is determined by how "into it" you are.
You can take just as nice of photos with a point and shoot as you can a DSLR.
"The secret to a good photograph, is knowing where to point the camera"~ Ansel Adams