Spinning off from another thread...
So? What do you like to do? Hate to see? Scream/cry when you see?
I like to a bit beyond 3rd normal form for a lot of things. I'm certainly not shy about spinning off data into a 1:1 identity relationship to ease the load on a table and keep less "immediate" data in another table (or to keep the table small -- they have limits for row size).
One thing that makes me scream inside is when I see structures that are below the 3rd normal form.
Another thing that makes me scream inside (and sometimes outside) is seeing tables with extra columns to store derived data in a parent/child relationship that needs to be controlled in code, when the simple and safe solution is to relate the table to itself with a foreign key to indicate the parent in the table.
Basically, any time I see a design where things need to be controlled inside of code, and not in the database, a little piece of me dies...
I do like joining tables on themselves for parent/child relationships. I don't really like it much for anything beyond a single join, but I'd go for 2 or 3 if I know that the usage won't be a problem and that it won't go beyond that.
I suppose that whenever possible, I like off-loading the work to the database.