I'm not a zealot, and i don't have any supporting documentation. What I will tell you is that you will get a lot of differing opinions on the matter.

I personally like case-sensitive collations, type key words in lower case, hate underscores and spaces in column names and table names, and use Pascal casing for names.

Now that I have had my say, I'm sure others will be along and post their thoughts as well.

Bottom line, it depends on what you prefer and the standards in place where you work. Sometimes you have to change to meet the standards where you work.