I don't understand what "drives you crazy"
really... you want Microsoft account tied to your windows 8 computer and then expect it to be insecure not asking for a password? I mean, like an official button from Microsoft? its your MICROSOFT ACCOUNT. with billing information, passwords and all, they just let you make your windows computer so insecure! not from them at least.
of course there are some ways to avoid typing a password.
you can try the usual control userpasswords2
also you can go to PC settings and tell the computer not to ask for a password if a person wakes up the computer.
you can put a pin and just type 1111 if it ask for a password, because sometimes it does.
or you can simply put your computer (and the easier and official way) in Local account! the only difference it wont sync anything, but you can add your account to your mail, and store and it would work the same, only without the synching stuff.
but its silly to say something drives you crazy because you want something that would make windows insecure because again, if you windows is tied to your Microsoft account, it becomes potentially dangerous if people can easily walk and turn on and change whatever they want to change or get billing information or something like that.
so I would suggest if you want it you can get it easily through local account. or the other ways like control userpasswords2. and see if you can avoid typing a password more often.