What I'm looking for isn't quite the same as a Pyrrhic victory, as the action isn't necessarily done to obtain victory. Rather, it is any action that will ultimately result in the person taking said action to pay great (preferably terrible) cost either along the way or afterward, whether or not they realize it in advance.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Old timey, but carries the meaning you seek:
You could try to pay dearly