Hello Pilgrim and Welcome to PR. I doubt if I'm going to help you much. This is a tough question to answer without knowing a little bit more of your needs and how much you have to spend. Some questions that will help us are:
1. How much do you have to spend?
2. Do you want to stay with a point and shoot or do you want to switch to a SLR (digital or film)?
3. How much of a learning curve are you willing to put into a new camera?
4. How much experience do you have with cameras.
Sounds to me like you are shooting in both bright light and low light. A point and shoot can work in these situations, but are limited. With SLR's your going to have to invest in some lenses, but will give you the greatest versatility.
All of that being said, maybe you can elaborate a little more on your needs and $$$.
Ken