Problem is Logitech software is worse, and I don't think you'll get the range you're after either. I think URC is still your best option. Your RF base will probably work with a new URC (and probably with Xsight (my personal favorite) as well if it's 433MHz), but won't work with a harmony.
If you want to give harmony a try anyway, aside from macros and durability, it will probably work ok for you. They're very easy to program and use and very popular, but definitely not made for the user who wants full control of the programming. I program them all the time for family and friends, but can't see using one in my own system since the macros are so limited or non-existent. And the buttons on mine always start flaking out after a year or two. I'm not willing to spend a couple of hundred bucks on new remotes every few years.
EDIT: Just to clarify, since you're coming from URC, you may not realize that harmony has two types of macros that they call activities and sequences. The macros which are missing in current harmony remotes are sequences, which consist of up to 5 commands run from a single button press. All harmony models still have activity macros, which handle power and input sequences and key mapping. Those are built by answering questions in a wizard. And if you use the old harmony software, you can add more commands and tweak some of the delays. So the macro situation isn't quite as bad as it sounds. However, if you want to put a simple sequence of your own on a button, you can't do that on most new harmony remotes. The ONE is the exception. If you use the old software, some of the lower models can do them too, like the 600, 650 and 700.