Back when I played a guitar out with bands and stuff regularly (um, 6 to 10 years ago!) I used a big spread of pedals -- mostly 'cause I'm enamoured of far-out spacey sounds, but I'm sure it helped hide my cr@ppy technique. :)
I make more use of straight-up overdriven amp(model) sounds now when doing my own demos (but this is also related to cr@ppy technique, since I can most successfully make myself sound competant by slamming out 2-finger power chords, and they don't sound so good with 500 FX shimmering around on top of them ;)).
Still, I gotta have access to the wah, and I like my old Boss analogue delay (not so much as a normal delay, but you can make the most fantastic/horrendous Dr. Who noises by leaping on it and wrenching the knobs around manically! I also gotta reach for the old Boss flanger on occasion, for those "jet engine on acid" sounds (leads or sometimes chords, in the manner of Monster Magnet's "Negasonic Teenage Warhead").
I guess these days I go back and forth a bit more between the two poles of either "pretty much guitar+amp" and "insane effect-drenched madness" without a lot of time in between!