This is only a valid way of thinking if you assume your target audience is a bunch of toddlers with the self-control of a wet washcloth.
As I and others have said before, a lot of us have no problem at all not picking a particular playstyle or piece of gear.
Simply because we choose to play in the way that is the most fun for us, instead of being on a sort of powertrip all the time.
I just dont see the fun in restricting myself to that one enchanted dagger when I much prefer the look and playstyle of a plain daedric longsword.
Also, there comes a point at which your player should be "overpowered" when compared to the average NPC in the game. It shouldn't happen at level 5, nor at level 10, nor even at level 15. But, as with the old Dungeon and Dragon games of old, once you pass level 20 or so, folks should start to understand that you cooler than the average cat and smarter than the average bear (possibly stronger as well). If you are a level 30 archmage who has taken the time to master all of the schools of magic, it would be immersion breaking if you COULDN'T cast an effective invisibility or charm spell. That is pretty much the entire point of being a Master illusionist. If you master a field of magic, becoming essentially a rare prodigy, a, wait for it. . . a MASTER, then are you not supposed to be able to do things that the average fella, even the average mage, cannot do? You are not unique, you are not a god, but you are a rare individual, of rare skill and extraordinary power. Its the reason you spent all those hours/days mastering those spells in the first place, isn't it?
As to the "temptation". The game must set bounds within reason. I.E. no Dagon's Razor for a level 2 player fresh into the game world and a babe in the woods. But "no overpowering magic" for a mage who has reached the pinnacle of his or her field? That is ridiculous in exactly the other direction. If the likes of Hannibal Traven, Mankar Cameron, Mannimarco, Dyvan Fyr or Galerion cannot manage to slip past a batillion of guards into a locked room and back out again purely on the strength of their magic. . . it is time for them to find new occupations.
If you don't want invisibility, Don't become an expert in illusion and DON'T seek out or create an invisibility spell. It isn't like those are things a player can just stumble into without meaning to. You actually have to put a fair amount of time and energy into the process. If you go through all that to get a spell and then complain about having it, you are not only bad at resisting temptation (the general you, not you specifically, former poster), but you are also highly inconsistent in your thinking.