It is associated entirely with
Harry Potter. I guarantee you that probably 80% of the US population never knew the name existed before that series.
I think it looks pretty spelled but the actual pronunciation is a little harsh. Herm is unattractive whether
Hermione or
Herman, and the eye-knee part is kind of harsh. I think the appealing character makes the name seem better to me than it actually is if I stop and look at it in a vacuum.