You want it to provide a ROUTE (navigation) or just location (where am I right now)? Since you're talking outdoor activities, are we talking mountain biking? Kayaking? There are few (zero?) apps that route off road. Some will have forest roads, tho, and some won't. My daughter works for a mapping company, so you might say I've heard a bit about this. Their app does not do routing. Yes, you can download maps for offline use, and there's a ton of accompanying info you can download, but their app is geared to hunters and routing is not an issue. She herself uses a different app for mountain biking. (Trailforks). If you just want to know "where am I", there are quite a few. And at that point, you start to care about layers. What other info do you want to see? Property ownership? Hunting info? Satellite image? Terrain? Slope? Unless we know what you want to do, it's tough to say what you need.
Be aware that the more detailed the map, the more room it takes up on your device. So, you may only want to download for the immediate need.
I use Maps with Me for driving and have downloaded not only my own state, but all the surrounding states "just in case". Because they are not satellite and terrain maps, they'll do. But I'd use either Google Maps for directions or her company's maps if I were looking for ownership info and just download the immediate need. Because they take up a ton of storage. I've been known to use my Garmin, Google, my car's navigation, and Maps with Me, all on one trip. Because these things are always letting you down at the worst times.