A curated list of the best discovery apps—scouting local spots, indie creators, and niche communities—with pros, cons, and real-world use cases for each.