No it is not. Mind Vision and Mind Games aren't really played. (Outside of fun decks such as "Randuin"
).
Now, Thoughtsteal is. It is actually good. Watch some Amaz's videos to see it at it's best.
It IS a quirky card, though.
It's basically Arcane Intellect with pros and cons.
Sure, it's "less consistent" and can whiff completely by drawing unplayables, but it's rare.
OTOH..
There is a strategic advantage in knowing that certain cads are still in opponent's deck and not in hand. Especially when they have one big finisher that you need to worry about (Grommash, Force of Nature).
Drawing from their deck
usually gives you decent stuff that you actually need. For example, if you are playing against a control, you are more likely to get lategame stuff, value stuff against midrange, cheap bodies for trade vs aggro (though it's at it's worst against aggro decks).
Having cards in your deck that aren't in your class is beneficial. It gives you more potential outs (before and after you cast TS). It makes people play around more stuff than usual, or get punished for it. Gives you access to things that you really need but cant have (weapons, for example), thus making you somewhat more versatile.
In lategame, versus slower decks, it virtually increases your decksize (cuz you draw two but do not lose cards from deck), which means that fatigue hits you later (you get to see/play 34 cards before fatigue hits, your opponent 30), which can be important.
It's not like "leagues better than Arcane Intellect" but it has its advantages.