I agree with a lot of your points, but it's important to note that being direct is not a free pass for being an asshole.

For example: if Bob sucks at SQL, and that happens to be one of your strengths, don't say stuff like "Man, these SQL scripts are trash" or "Dude, your SQL is ass, let me write it" - instead, something like "Hey, I noticed our db code is looking pretty rough, do you want some help cleaning things up?".