I've always asked for, but never seen, a convincing case where something really definitely needs per-pixel collisions and just can't be done with polygon collisions.
Worms-like terrains and terrain destruction. I tinkered around with it some time ago and it is pretty much impossible. A tilemap works but imo not that well. I had the idea to divide everything into reasonably tiny pieces/triangles. Works ok with simpler terrains but then you can´t really use textures, unless you manually cut it up and individually place each piece. Well if that process could somehow be done at least semi-automatically it would be really cool. Like a "shatter" plugin that sort of triangulates the object automatically into multiple small ones and then allows the pieces to be broken away individually.
I wouldn´t mind though if you go ahead and prove me wrong about it beeing that complicated, maybe make a worms-type template :)
But I would agree that this is a rather specific case and isn´t that important on a larger scale.
(Also that´s kinda offtopic from what OP wrote)