I almost bought the ultimate but the most used buttons are above the touch screen and that doesn't work for me. I want the most used buttons to be hard buttons close to my thumb. I was using a harmony 520 which has the best layout imho but I have worn out 2 or them and the dog ate one lol and they are no longer available. I bought a harmony one off ebay and a extra battery with charger for when I forget to put it in the cradle. The one is pretty good , but its taking some time to figure out the buttons without looking.
I have never had a URC remote , the harmony's ive had don't use macro's but they have activities and can be somewhat modified with delays and such. You can switch between activities and devices easily with a single button touch as well as map different device operations to different buttons on the touch screen.