I also have a great-grandfather
Horace, albeit one without a tragic, romantic backstory. It's not a name that clicks with many people. Due to its sheer ugliness, no doubt. If I wanted to honor
Horace, I'd go with
Horatio, too, or perhaps
Orazio.
I don't watch CSI, so I can't address the impact of the character. My sole
Horatio association is
Horatio Hornblower. Kinda cool.
I like
Horatio Calvin, in part because I'm tired of
William as a middle name, but both combos work.