Take a look at
this thread.
Depending on your level of expectation, you're looking at some serious equipment for Spectromagic and Fantasmic, the two most-difficult-to-photograph things in WDW.
First, you need a big sensor (in order to have a high ISO level - you'll probably have to shoot at 1600 or even higher). This knocks point-n-shoots out of contention, you need a DSLR like a Pentax, Nikon, Canon, or Sony.
Second, you need a "fast" lens, one that lets in a lot of light. This means that the "kit" lens is probably out. I found that a 50mm 1.4 (about as fast as you can get) worked quite well for Spectromagic. Fantasmic requires a lot more zoom if you want any kind of closeup, and a "fast" telephoto lens gets very big and very heavy, and very expensive. I really didn't even bother trying to take shots of it last trip as I didn't have a suitable lens.
Unfortunately, a tripod is not a great cure for Spectro or Fantasmic as the subjects are moving too much. It can help, especially for Fantasmic where you're so far away that the camera will register more shaking, but a tripod only will not cut it.
A tripod (or Gorillapod or similar) is pretty much mandatory for really nice night photos of still objects (castle, etc) or fireworks (where a longer shutter speed is desired.)
Unfortunately, a small, inexpensive, easy-to-use digital camera that can take sharp, clear photos of Spectromagic and Fantasmic just plain doesn't exist, and probably will not any time soon. There's just no way to sugarcoat that fact.
On the other hand - digital pictures don't cost anything, so fire away with whatever camera you have, and you may find that you get some decent results mixed in. You may also consider just taking some short videos with your digital camera.