During the BoH, Hermione puts a couple of Death Eaters out of action by transfiguring a staircase into a slide, and turning the tapestry at the bottom into stone. It does seem like transfiguration would be useful enough to have come up a bit more often than it did, though.