Just to add, although it's outrageously unfair, a lot of people (at least subconsciously) will put the 'blame' on the person with the unusual name for having it pronounced wrongly and think "Well, you shouldn't have such a 'silly'/'difficult' name if you don't want people to get it wrong". Plenty would even think that with foreign names as well.
I know it's not the same thing (and Horatia isn't being misspelled at all, nor ridiculous), but do you remember when the defence company unveiled their new name of 'Qinetiq' 20-odd years ago? People who heard it fell into one of three groups - two vast majority ones, where they either didn't have a clue how to pronounce it and just stumbled badly or refused to even try (they might not even have heard the actual word 'kinetic') or where they deliberately pronounced it wrongly (as 'queenie-tick-wee' or whatever) to show their scorn for what they saw as a ridiculous name; and a small minority who wanted to be respectful and thought "Ah, right, so it's an alternative spelling of Kinetic - I'll have to try to remember that, but still can't guarantee I'll get it right if I ever have to write it down".
I'm not suggesting that Horatia is anywhere near as difficult as 'Qinetiq', or attention-seeking in the same way, but your name is a practical way of identifying/communicating with you and any name that might potentially cause widespread confusion or seem a bit too long (imho, I think four syllables is too long) will be naturally adapted or shortened into a de facto alternative name, so your chosen name will effectively not really be what they are known as everyday anyway. Many Brits would have to stop and think for a moment if you asked them to put something in the refrigerator, for similar reasons; some would not even know what you meant at all.