I'd say Hillsborough and Pittsboro are definetly very similar, both in atmosphere and cultural/community opportunities. They both have that kind of "Chapel Hill" flair to them, which would make sense if you've ever been to Chapel Hill. They, also, are pretty quiet little towns, but so is Mebane. Mebane kinda straddles the Triad and Triangle, some consider it one, while others consider it the other.
The bottom line on Mebane and Alamance County is that they are working class areas and you can tell it. If that bothers you or if you don't want to be in that kind of area then steer clear. I have found that many in the Triangle kind of cringe when you mention Alamance County; it's viewed as this conservative hick place that is nothing but rednecks. I personally live in Alamance County and that is true for many areas, but not for the whole place. The eastern end of the county tends to be more influenced by Chapel Hill/Orange County in both people and in housing prices. Don't write it off until you see it for yourself, you might like it.
I believe someone mentioned schools somewhere along the way in this thread. Alamance and Orange County are very comparable. When comparing to Chapel Hill-Carrboro City Schools everything is going to seem like crap. Just sayin