I find my effects great fun, but practically speaking I use them as effects in the same way that a movie uses effects to achieve something out of the ordinary. Too much effect limits my ability to change the sound and dynamics using my fingers.
Now I have an amp with a valve preamp the utility of my MojoMojo is becoming moot as just digging in creates the massive sound I want and the jury is out on compression.
A tuner is useful, but not essential, ditto an HPF. A chorus is handy for things like Purple Rain, and I will probably move this to be in the post preamp effects loop.
My collection of overdrive, fuzz and distortion pedals are possibly redundant unless a real need comes along. Octaver is great, until other people join in. Phase, flange, tremelo* don't really suit.
*Worked a treat on boulevard of broken dreams but the concept of a drummer taking his tempo from one of my effects didn't work.