Well I pretty much agree with the general consensus, I did run into one instance where I interviewed with a company and during the interview I told them they really didn't need a full time programmer, and would be willing to assist them on weekend and evenings.
The General Manager stressed that Oh Yes! We have plenty of work for you. They made a good offer, and the benefits were good.
I returned to my current company and gave them 2 weeks notice. The Regional Manager did counter offer but it wasn't as good as the new company, so I said thank you for the generous offer but I'm going to take a chance with the new company.
I was with the new company a year when they decided they didn't need a programmer at all, general manager was in tears when she told me, but what can you do.
My position at the previous company had been closed out and wasn't going to be filled. So to the Job Search Sites and polish my resume up.
Excepting a counter offer would scare me a little, the company/manager would remember that you were thinking of leaving and you might be the first to go in a RIF.
Another incident, when I first got my Computer degree, I was offered a job and excepted it. Took the Plant Manager I was excepting a new job. Then the position fell through, now I had no place to go. Told the Plant Manager and his reply was ... No problem, I'll extend your resignation until the end of the month. Well ... you can guess how I felt. It worked out, the same company interviewed for a position in another location, I excepted that one and was able to attend a major University and get my Bachelor's Degree in Computers.