The thing is that we like to think that insanity is somehow the same as being visionary or eccentric, and it's not, any more than losing a leg means your other leg now has super jumping powers. It's having a brain that is not working the way it needs to; it's being crippled in a way. And it's very sad and painful for the person who has it. The way it's romanticized, I think, trivializes that.
Norman, when it comes right down to it, IS in over his head and is not really equipped for all this. And when he goes crazy, his brain just breaks.