I haven't lived there in 5 years, but the best restaurant there was a very small Mexican place next to McDondalds on Franklin. (I don't remember the name, but it was great!) Don't fall into the Armadillo Grill propaganda...it is lies! there was also a good place called Bravo's outside of Carrborro near the dog park.
AVOID 96 rock at all costs. If you want to listen to the radio, the only real worthwhile thing is 88.1 WKNC (NC State's college station).
In my opinion, the coolest parts of the Triangle happen away from the campuses (for example, the best meal I purchased there happened at an unlicensed restaurant in some lady's apartment), but you sort of have to find those things yourself. If you want to see bands, there are plenty of places to see them, but (unless they are are huge) the shows are usually on weekdays.
If you want to understand where you actually are in the country, spend some time in Graham, Wilson, or Winston-Salem. What happens in Orange County isn't really North Carolina. If you plan on only using it for school, then it doesn't matter, but if you plan on staying, check out some of the small towns around UNC and Duke and see if it really fits.
The most hilarious part of North Carolina is a place called Paradise Club. I have never been inside it, but seeing it from the outside is enough. It's off of 87 on the way up from Chapel Hill to Graham. You only need to pass it to understand it magnificence. Enjoy if you dare.
