Help: stuck with passwords

Curious how others approach passwords.

This came up at work last week and I couldn't let it go.