That being said, I think it would be nice if Google made this particular functionality optional. For some shared user environments where you want to maintain the illusion of privacy (e.g. "family computer"), it might be nice to force password to view more sensitive information (e.g. e-mail).
I won't comment on DropBox because I don't expect any better from them with regards to security.
Agreed. No difference for me since I have my Google powered mail all going into Mail.app which does not require a password, but in some shared environments I definitely see the point. Though in a shared environment you should be using different accounts otherwise stuff like Google Drive and Dropbox don't really make sense anyway.
Basically if you leave your account logged in, it's expected behavior that anyone who rolls up to the console has access to everything that account does. This is not a security issue at all.
Edit: I think I accidentally downvoted you...
Update: I should add that this probably should be optional since it goes against a reasonable expectation. But considering it requires an "attacker" to have physical control of the computer, I don't find it super serious. Dropbox behaves the same way (though I guess you usually don't see anything else on the web that you can't on the desktop).