For a laptop, then you definitely want to login at startup; and also supply your password to wake the display.
If someone can sit in front of your computer and do stuff with it, then that's half the security gone right there.
For a desktop in a private room, where other people's access is limited, then auto-login is fine.
Just to be clear: you should definitely HAVE a password for your user account, even if you auto-login.