Wow, were going from P&S to DSLR's.
If you want a good camera with manual controls, then a lot of manufactures offer manual modes in their point and shoot digicams (such as the Canon S series someone mentioned). One thing though, if you plan to buy a point and shoot camera and plan to take low light indoor shots, make sure they have an auto focus assist beam. It makes focusing in low light a lot easier.
If you are looking at a step higher, e.g., hot shoe for external flash with full manual controls, then look at the Canon G series and the Sony V1 or W1 or the F717 that dropped the price by a pretty good margin.
I don’t think you are looking for a DSLR so I won’t comment on that, but it helps in the future if you give us an idea of your skill level in terms of taking photos. Check out the reviews in
www.dpreviews.com, dcresource.com, and steves-digicams.com. Good luck with your search.
edit - grammar