The detective mode discussion in the podcast made me hate the idea of detective mode less, but I am still very much not a fan of it in open world games. It's even worse when combined with waypoints and map markers and what have you.
Horizon makes use of it far too many times, it's almost parody. However, at least it implements the mechanic with one press of the button and the trail is there (ignoring the fact this is then repeated multiple times through a side quest.)
The one little change that could've made Witcher 3 less frustrating when using Witcher Sense would be to make it the same one button-press. The fact that you have to hold it down throughout the highlighted objective means the beautiful world is covered in a horrible filter for half the mission and the player is now completely un-immersed. Whereas they could be happily following the trail whilst admiring/immersing themselves in the world around them.