I'm not familiar with Windows nowadays. If it wakes up locked and asking for a password you are fine. That's the setup of my Ubuntu laptop.
Lock the PC, leave it on a desk, it goes to sleep. You come back, wake it up, type in the password to unlock. The weakest link is remembering to lock the pc. Auto lock after some minutes is ok only at home.
The password manager locks when the computer goes to sleep, I'm not sure that it's optional behavior (and if it was I'm not sure I'd want to disable it)
Lock the PC, leave it on a desk, it goes to sleep. You come back, wake it up, type in the password to unlock. The weakest link is remembering to lock the pc. Auto lock after some minutes is ok only at home.