You might want to consider getting 2 effects one that you can leave on for slow songs another for fast songs. a good choice for slow songs and to leave on all night is the Am Dj Starball II it gives the old mirrorball effect and can be run all night witout any problems.
The other effect should be a bright colorful effect such as the Revo's