I would agree with 80% of what climber is saying. However, the Op mentioned that he will be taking alot of indoor pics which means that low light ability is an important consideration. A DSLR will generally be less noisy and allow the user to select a higher ISO so as to avoid using flash while handholding.
My personal bias - let me first say I really like the Canon S100, however, for many instances where a P&S form factor is appreciated I think something like an Apple iPhone will do. Therefore, I don't see the need for a p&s if one has a nice smart cameraphone.
Depth of field - control over this is very important even to beginner photographers, and the OP wanted to grow into his camera. Hence, if he doesn't mind the bigger bulk, then a DSLR is the way to go. As I said, the Canon 5DMkII will be dropping in price and this is a great camera (full frame is in my opinion the way forward - I am old school film guy and the crop sensors just don't do it for me). The camera is not important used to be the mantra in the film days, but with today's digi cams, the camera is becoming increasingly more important.
But then the OP never stated his budget, so whilst a 5DII is value to me, it may be too much camera for him price wise.