I really don't know anything about specific camera brands except for Nikon. I just happen to like those. All the major camera brands, Canon, Pentax, make fine cameras.
The Nikon 3100 for example comes with an all purpose lens. B&H has that kit for $450. It's not particularly fast, but you'd get very nice daytime shots with that. The 5100 is a step up from there. If you use a tripod, you can also get decent nighttime, non action shots with those. For that you'd need something like the Nikon - AF-S DX Nikkor 35mm f/1.8 Lens as a faster all purpose lens. That lens goes for about 190.
You'll want to see how different cameras feel in your hand. Some "fit" better than others. Try them out!
You might also want to to check out the used camera market. Some folks tend to trade up as soon as the latest and greatest is out and some nice used stuff can be had for considerably less than you'd buy new. Maybe you can find a nice used D90 or something like that there. (Many Disney photographers still use D90s, but what do they use to help get those nice crisp shots--that's right--a tripod).
Be prepared: those DSLRs add a lot of weight during the course of the day compared to the Point and Shoot variety. There's quite a learning curve to them as well, but you will reap rewards for the time and patience expended.
I'd strongly suggest a hop on over to the Photography board. There's a ton of great information there.
Remember, no matter what camera you're using 90% of a great photograph happens before the shutter is pressed!