I have 2 point-and-shoots, Canon PowerShot S100 and Canon PowerShot G1X. Both have manual controls, but G1X has a huge chip, so it takes better photos.
I mostly use the small one though, carry it around everywhere, it's ultralight and pictures are great. When I know I'm going to take pics, I take the G1X.
I had a DSLR ages ago, but I opted for smaller, lighter cameras. These days the upper-level P&S can take great pics (often better than lower-level DSLRs), so there is no need to hurt one's back with carrying a monster (I mean that for myself, my neck was really suffering) or not being able to take pics because you didn't take the monster with you. :-)
Just for illustration, I found this comparison of G1X and 7D:
http://dpinterface.com/2012/03/12/ca...th-comparison/