I have taken advantage of this in the past, and it's a great deal. However, I believe it works best for "quasi-locals," who can check the weather forecast a couple of days in advance, then plan to go.
With my job (partner in an ad agency), I don't often have down time during the week. But over the winter months, if I see a day open a few days out, I always check the forecast, and if I'm free and the weather's nice I'll book one of the one night stays. (I live about 1.5 hours from Pinehurst). One of the joys of living in NC is the occasional Dec./Jan day in the 60's... Of course today in the mid-70's wasn't too bad either!