Another vote for the WR7. We have 4 XBMC instances (a mix of OpenElec and Windows), 3 receivers, 3 flat panels, and a projector and each has its respective WR7 remote that works with everything. I also love the Harmony's, but with kids and tile floors, they are prohibitively expensive. With the WR7, I can afford to have a spare on hand.
In addition to the WR7, I also have been able to match up most of the DirecTV remote to keys to mirror the WR7. If the WR7 is missing or out of reach, the DTV remote will usually work.
If the WR7 had RF that could control the DTV, it would be perfect.