Years ago, when we received our first ATR 75s, I used to set the trim SLIGHTLY nose heavy, as I didn't want some rookie FO to scrape my tail...
Btw, I have noticed there is a common tendency to rotate faster than the recommended 3° per second.
Better to have it slightly nose heavy and having to apply a little input maybe at the end of rotation, than the contrary.
I can't recall any accident for a nose heavy airplane, but there are for tail heavy ones... they eventually stalled... but of course these are extreme circumstances.
Today, on the B737, I always set what they write on the loadshett, and when that's incorrect, I don't know why the result is always nose heavy, luckily.