Regarding the latter part about “nerd” interests, you can find plenty of it, perhaps due to the large university and tech population that supports and embraces such pursuits. If you dig into this sub you can learn more, but Squirrel Hill for example has independent bookstores and a pretty cool board game shop.