The two movies I've seen which do slow-mo really really well are Dredd (Karl Urban version) where it's used in context with narcotics use and the Sonic the Hedgehog movie both of which as you say really do use it sparingly.
I've still got to get to watching these, perhaps this week fingers...