I think there's a specialist for almost every geography and niche of the market. It's more important to understand the best/worst geographies and property types for your specialization, aspiration, and capability.
If you're an investor looking for cash flow, stay out of Ansley Park and Virginia Highlands. If you're looking for strong equity growth / a flipper / looking for low-touch self-managed properties, stay out of (relatively speaking) stagnant war-zone pockets of the city (e.g., Bankhead, Adamsville, Constitution). If you want a highly-secure investment not likely to drop in value in any market, don't buy a high-end condo or new construction anywhere, especially in high-end neighborhoods. If you're a BRRRR strategist, you'll be well served by an up-and-coming neighborhood (e.g., East Point, Hapeville, College Park, Sylvan Hills), but you might find the spread too thin in a more mature area (e.g., West End, Adair Park, more and more Pittsburgh).
How did I do? Anyone have a different point of view? I'm sure there is a counter point to almost every point I made, hence, the caveat of your specialization, aspiration, and capability.