I think Francesca's on Ninth Street in Durham is great! I don't drink coffee so I don't know if there coffee is that great, but the atmosphere is definitely great for people watching, general relaxing and hanging out. They have great desserts and gelato and occassionally have folks playing music and such.
more