What are spells that seem useless, but are not?

Often when I play most of the spells I find seem useless, but I have a feeling that there's always a clever use that I haven't thought of yet. What are your favorite spells that subvert your expectation?