Writing Woes

Has anyone else ever realized mid way through writing something that the story has suddenly gone off in a completely different (better!) direction than what you had originally planned, and you find yourself with a few thousand words that no longer fit anywhere?

There's nothing to do but delete, but geez, getting rid of that much work is just painful. :/