Resign or accept a counter offer from current employer?

I've typically read that if your current employer tries to counter an external offer when you resign, you should generally still resign. This way there is no bad blood, and your management chain doesn't have a preset head to chop when layoffs occur. Contrary to this, has anyone ever actually accepted a counter to stay and continued a longer term career, or is it always doomed long term?