I just moved away from Durham. If you can afford it, stay at the Washington Duke Inn. If you want to go cheap but decent, go with the La Quinta on 15/501 (aka Durham Chapel Hill Blvd).
Durham isn't the greatest town, but a game in Cameron is worth the trip. Make sure to hit up The Q Shack for some BBQ (get the Carolina style pulled pork and use the vinegar sauce). Head to Main St if you want to hit up a bar (The Federal or James Joyce were my faves....but aren't anything amazing). Also, getting over to Chapel Hill is a very good time and a much better college town. Anything on Franklin is good.