If you want a standalone, OTA DVR that "just works", and won't give you headaches from time to time like all the others, just go with the TiVo and be done with it (jjeff is right - you do get what you pay for with these things).
You can get a brand new TiVo Premiere, with an OTA tuner (latest model), on ebay, for only $80 (w/free shipping). Then, go to www.retailmenot.com and search under "TiVo Coupon Codes", and there's one right at the top of the list, that has an 80% chance of working (code is "PLSR"), that'll give you $100 off the lifetime service. If that one doesn't work for you, just do an internet search for "TiVo coupon codes", and you might find one that does. People in the HDTV Recorders forum here are still finding ones that do).
When you go to the TiVo.com site to activate your unit and sign up for lifetime, just enter the promo code when they ask for it (I think they ask at an earlier point than when you actually hit the final checkout prompt, so watch for it). You won't get affirmation of the discount until you get the follow-up email.
Total comes to only $480.
There are two, separate forums here for streaming (not including the HTPC ones) - one for hardware, and one for content. They're easy enough to find. PlayOn's got a discounted deal going right now. It's inexpensive (I think the lifetime fee's only $40). Hulu (not Hulu Plus, which you have to pay for) is available through PlayOn. Netflix you have to pay at least 8 bucks a month for. The PlayOn site has the pricing, available channels, and all the other details you want.
The Roku has hundreds of official and private channels, and lots of free programming and good, free movies (like on Crackle). Two good sites to see what's all available though it are Streamfree.com and Catastrophe girl.com. The Roku also has apps for Netflix, Hulu Plus and Vudu.
Edited by Rammitinski - 1/27/13 at 9:14pm