I'm not a zealot either, but I prefer all lowercase with underscores instead of Pascal or CamelCase for object names, although I do like uppercase key words.

I don't like case sensitive collations, but by using all lowercase and underscores I can handle case sensitive collations when it comes to object names.

The main thing to me is that an organization have a standard and everyone sticks to it. My current project someone else created the database objects and used Mixed_Case with underscores. I can't stand it, but when I create tables or columns I use that standard. Because I did the stored procedure development stored procedures are in all lowercase with underscores so we have slightly mixed standard.