I think a lot of the time people put too much of an emphasis on the camera. Sure, a DSLR is going to do a great job in the right hands. However, I see so many people in WDW with DSLR that really have no clue what they are doing. It is painful to watch someone spend 12 minutes doing shot after shot of IllumiNations with a flash. What is even more amazing is that after each shot, they look at the screen, see the shot is rubbish, but then just carry on. It really seems like the only reason they bought the SLR was that it was expensive and is what pros use LOL.
Not only did they get terrible photos, they also missed the entire show.
I have had great photos (and lots of not-so-great photos) with a $300 compact Panasonic Lumix, and great pictures with a DSLR. If you take the time to learn what you are doing with your equipment, you can certainly get good results with whatever you have.
If you arent using an SLR -
1. Use any Scene modes your camera has. The manufacturer spent a lot of time developing them, and they do work in a lot of instances. The camera will then setup the camera to the best of it's capability for the type of scene you are shooting.
2. For any kind of night shot, you need to keep the camera very still. The slightest bit of motion of the camera and it's game over.
3. If you dont intend to light up a scene, dont use flash. If you try to shoot fireworks or Spectro with a flash, all you will do is light up the 10ft in front of you, and that isnt the effect you are going for.
4. Take lots of photos, and look at the monitor as you take them. See how things are coming out, and make adjustments as needed.