Looks like you are just looking for a replacement P&S-sized camera with better IQ and better low light capabilities. Also with tilting LCD if possible.
Since you're used to having a small form factor and a zoom lens, here's some suggestions. I omitted DSLRs altogether.
1) Get a top end P&S like the
Fujifilm X20,
Canon S110/S120 or
Sony RX100 II. The IQ of both won't match up to DSLR levels but should be better than your SD1100 for sure. The
Sony RX100 II will likely show a marked improvement. And these have the option of just sticking to Auto modes. But you're locked in, i.e. once you take this option you are stuck with the whole package.
2) Get a M4/3 camera. IQ is just a stop short of DSLR levels, but the size is small and you have the option of expanding by buying other lenses later on. You can get this with a kit lens. If you find that the images are still too blurry you have the option of buying faster lenses ($$$). Some models include
Olympus EPM-1,
Olympus EPL-6 or
Panasonic GF6. This is slightly larger than P&S cameras, and definitely less pocketable.
3) Get other mirrorless cameras, like the
Canon EOS-M,
Samsung NX series and
Sony NEX-3N, with the kit lens again. Same issues as #2 but IQ should be even better because of sensor size. I would still recommend M4/3 over these, even though the low light performance will be better, because of the extensive amount of lenses available. The M4/3 segment at present still has greater potential than any other mirrorless cameras.
If you want a tilting LCD you can look for one with that option. I'm sure some of these will have it.
Most importantly, to get the best results out of these cameras which all have the option of going to manual control - it is best that you understand photography a bit better. You could take some time to read up on basic photography here:
http://www.clubsnap.com/forums/showthread.php?t=309544 (that's a thread by a fellow member sulhan here, which is pretty good) Understanding of the basics will go a long long long way to resolving your issues such as blur images, exposure (too bright/dark), etc.
Cheers!