Would be very useful, actually, I just don't think it can be done with the way tiles have been implemented. Some uses...
Destructible tiles like in Metroid
Pinning tiles to moving platforms & interactive objects
Making tiles transparent/invisible to reveal hidden paths
Well, now that I think of it you can just use a separate tilemap object with your tile(s) of choice. Not the easiest way to go about it but whatever..