Zelda Botw has the most elegant map towers to date, yet after unlocking 10 of them I've come to the conclusion that revealing the map that way is still more harmful to the game than beneficial. I've noticed that I'm having more fun exploring uncharted territory right up to unlocking the tower, than afterwards while 'finishing up' a zone after the map is revealed. It's great Botw doesn't litter the landscape with icons, yet putting down names everywhere is basically the same thing, except now you can't easily check where you've already been. Plus the suspiciously unnamed geographical features are a dead giveway for being an important place to go.
Climbing the towers and solving how to get to them is handled greatly. Not just in Botw, FC4 had nice variations too, and Horizon takes it to another level (or so I've heard). However when that map gets revealed it feels like a big spoiler to me, so much so I don't intend to unlock the few I have left until I've completed exploring the zones. I get why it's there, otherwise go to the west of mount such and such wouldn't help you much for directions. Except with the map already revealed you simply mark the spot and it's not all that different from the game putting a quest marker down for you.
Before map towers we used to have auto mapping, the map gets filled in as you walk around. Great way to track where you've been yet not that useful for directions. Although that simply needs better directions, npc's that actually point in the direction you need to go or draw some crude directions on your map. Map towers could still work with that by giving a crude layout of the land with the roads for example. Or make use of the elevation and map that which you can actually see in crude detail which gets refined when you visit those places.
Then there are games with no map at all like Dark souls for example. It would be a bit inconvenient in open world games yet it never bothered me in Everquest. It was actually much more exciting having to remember the way back and fear getting lost on the way.
Tldr: Climbing towers great, revealing the map in large chunks, not great. Bring back automap.