This is where locals have an advantage. My friend lives in CO and knows a bunch of fantastic hikes that maybe are not in a NP or that tourists don't know about yet.
TBH there's not that much of an advantage over someone just doing their homework before a trip. For things like hiking trips I highly recommend going on AllTrails and look at places there, you can find tons of awesome spots on there.
