Well, I'd always favoured polled cows until my younger son fancied some Highlands.So, in order to maintain his interest in cattle, we encouraged him to get some.
In actual fact, because the horns are so obvious, you cannot but be aware of them and keep a respectful distance. In fact horned cattle are no more likely to purposefully impale you than polled cattle are to butt you. A placid animal, whether horned or not, will not deliberately hurt you without good reason. (Like it's just calved.) A bad tempered one of any sort wants getting rid of anyway.
So - I would say that if you like a horned breed - go for it.