Shooting higher ISO, either film or digital, is just like crack cocaine...You get higher shutter speeds, smaller apertures (thus greater depth of field), shoot in heroicly low light conditions, get great stuff deeper, smaller strobes...on and on...
Of course, just like drugs, you pay for it later. With digital, it's noise...with film, it's grain. And of course, at that point, you pay for it forever.
The bad part is, you won't notice it while reviewing on the camera's LCD. It's later, when you're printing that award-winning moment, that you silently curse under your breath.
I shoot ISOs as low as I can as a matter of course. However, there's times you just need the shutter speed:
Sports (surfing, swimming, I shot U/W of water skiiers once)
Surge
Or, when you need the depth of field:
Big distance between foregound and background
Lens is at the verge of needing a diopter
Over/unders with rectilinear lens
Fast-action stuff set at hyperfocal
Or when it's just plain dark:
Late/early in the day
Heavy overcast
Deep
Low vis
Depending on the situation, I'll rachet up the ISO, but only with the greatest of reluctance. Like going to the dentist.
All the best, James