Yes, Durham is very nice (and Fullsteam is pretty great), but the part you visited is very small and not representative of the rest of the region at all. Raleigh also has a tiny, and nice downtown. However, the region is still a snarl of highways and unsustainable suburban sprawl.
Say what? I visited Durham recently and had a blast -- lots of cool local businesses (Fullsteam Brewery was an amazing find) and neat old warehouses and charming old houses and such. Carrboro was also great, people biking everywhere and local hippie markets and stuff.