Mild Curse: You can never remember if you locked the door. If you go back to check it, it's locked. If you don't, it's unlocked.

I won't pretend it wasn't at least somewhat informed by personal experience.

No, I think that would be a severe curse. It just happens once per each time you use the door and intend to lock it.