Avatar : Frontiers of Pandora has had me going like Rowan when played in explorer mode. It gives you hints like in other recent Ubisoft games but holy shit some of those were near useless... I wasted entirely too many hours just exploring and circling around the correct answer. I recently switched to the more friendly Guided mode and it has the waypoint only appear in Hunter mode, so that was kinda nice. Hasn't completely spoiled the experience although I still wish it would only activate once you were in the vicinity indicated by the clue (ie, if the clue gives you some corner of the map to explore, then the guided mode would only start helping once you've reached that general area).

But yeah, overall, I disagree with OP. Make it optional, make it diegetic, make it subtle, but the option is a wonderful game design element, in my book.

One thing I think is that the longer time you need to use it, the harder you've failed in you basic design, because I shouldn't have to press the damn button 90% of the time like I used to in Far Cry Primal. That game is still my favourite as a precursor, but I was using the hunter vision way way way too much.