Sometimes the right choice seems great at the moment, but...

Sometimes the right choice seems great at the moment, but then suddenly it's as if somebody detonated a suicide bomb.