Do abilities like familiars, and scribe wizard's manifest minds etc make scouting/dungeons unfun? Where's the narrative tension?

I think it is still fun. Just a different kind of fun. It shifts to a taktical game with lots of interesting strategic discussions instead of an exploration game.