If you don't think you will get really serious about photography, then skip the DSLRs.
Once DLSRs are out of the picture you have to decide what kind of optical zoom you are looking for. Up to about 10x optical zoom can be had on a reasonably compact camera, anyting over that you are likely getting into the mega-zoom class of cameras that are quite deep because of the monster lenses on them. I have a Panasonic Lumix FZ-18 with a 18x optical zoom and find that the camera really is just a bit too big to carry around all the time.
If you want some of the more custom controls, such as manual focus, you will be looking at the higher end of the Nikon Coolpix range, or the Canon PowerShots. I personally have been looking at the Nikon Coolpix P7100, and while it is not a small camera, it is also not a huge camera, but it has a great feature set and a slightly larger sensor than the pocket sized cameras.
All of that to say that you really need to decide what features you are interested in first, then you can start doing full research. I found
Digital Photography Review to be a good reference.