The best remote you can get for regular use is the URC-R6. It is a full button remote with all the DVR buttons and it has learning capabilities, which is excellent. I use these in my bedrooms and spare rooms. Can't beat it for $13 bucks.
[Link: amazon.com]