Steve Kline is 100% correct when he said they ruined #4. It went from being almost as good as #2, to being something I wouldn't pay more then $75 to play. Club Corp changed it all in the name of the mighty dollar. They wanted to charge a big surcharge to the resort guests so they brought in a "name" architect (I guess Donald Ross wasn't good enough) to redo the course. #5 used to be a lot of fun too, but since they changed #4, the older members don't like playing it as much and in order to appease them, they made #5 easier. They ruined all of the green surrounds by flattening them. I almost don't want it play it anymore either. Too much 'What used to be' with #4 and #5. I haven't played #8, but have only heard bad things about it. #6 is a great golf course too as is #7 but I haven't played it since they did some work on it. #1 and #3 are a lot of fun, but very short, though if they charged $40, I'd play them everyday!
I guess not enought people have played Pinewild for people to talk about the great courses there. I used to be a member at Pinewild and I rank both courses just behind #2 and Pine Needles. I haven't played Forrest Creek so that's why I can't rank it ahead of Pinewild. Both courses at Pinewild (the original Magnolia by Gene Hamm and the Holly by Gary Player) are plenty long and both different from each other that I can't decide which I would rather play if I could only play one of them.
I don't know if Sean Arble is still reading this, but Hyland Hills is an outstanding layout, but the conditioning isn't always up to snuff. The greens are usually great (all that matters to me if the price is right) but the key is to find out when the cheap rate starts. The time changes seasonally (between noon and 3pm), but you can play the course for about $25 including cart (it's very walkable, but there is a lot of elevation change) and besides Southern Pines is the best deal in the area. Though, Southern Pines tried to charge my dad's group $70 in mid Oct. last year so they played elsewhere. The one thing about Hyland Hills is that the 6th and 12th greens need to be exploded and rebuilt. There is so much slope on them that they are almost unputtable except for a few pin positions.
There is not a lot of night life other than what is mentioned in the other posts. It's a small little town and golf is number one. I will second that the Barn is a great restaurant. Also, on 15/501 down in Aberbeen is Bob's Barbeque which is always packed.