Trali at Brier Creek is really good. Its the first time in my life I've been called "lass".
http://www.traliirishpub.com
Also if you do come to this area and enjoy hiking, then I highly recommend taking a trip out to Grandfather mountain. Its one of the best hikes around.
I don't think the triangle area is touristy so I don't see many visiting except for business and school. But it is centrally located so its easy to take weekend trips to enjoy the coast, mountains, virginia, sc, etc.