Spirit Vision in normal gameplay increases the chance of finding rarer items and allows you to cheat in certain mini games.
I tried searching nearly every area with it enabled and I didn't see any difference, sorry. And the minigame cheating makes sense, but it didn't cross my mind ever.