Anyone mentions "dual tuners", I know they're coming off a TiVO or cable-rented PVR. Man, are those folks disappointed when they visit here!

The state of the USA market for standalone video recorders is, in a word, nonexistent. Even when it was in its prime back in 2005-2006, they could not match TiVO boxes or cable/satellite PVRs (which is what finally killed them): no dual-tuner options were ever offered and they don't come anywhere near HDTV image quality. They were/are a compromise solution intended for users who prize making permanent DVD recordings over convenience or HiDef.
The only options still available in US stores are the Phillips/Magnavox units, extensively covered here by wajo in his sticky thread. That's it: there's nothing else. If you're willing to shop eBay you can buy Canadian-market Pioneers, which are excellent but don't have built-in ATSC tuners: they're more suited to cable reception. Pioneers are highly sought after by US hobbyists, which drives the final delivered price to $300-500 depending on the model (Canadian residents or tourists can just walk into a store and pay half that.)
I'm partial to Pioneers but most of the members here on AVS are Panasonic fans. The most popular of these were the EH55 (DVD/HDD) and EH75 (DVD/HDD/VHS). Nice units, but totally pulled from both Canada and US quite awhile ago and scarcer on the secondary market than Pioneers. Prices for "new-old-stock" still hovers around $475-600. People pay these prices largely to get Panasonic's exclusive TVGOS timer system. Broadcast support for this analog system seems to be fading rapidly and may soon be limited to a handful of cable vendors and DiSH, so "classic" Panny prices are starting to drop a bit. If you're patient, you could get an excellent buy after Feb. 17th.
The last of the "big three" quality mfrs of DVD/HDD units was Toshiba. Their 2004-2006 series was arguably the best ever made, but they're flaky as all hell and difficult to repair. Panasonic and Pioneer are a safer bet as discontinued models. Current USA-market Toshibas are disposable non-HDD units: they have nothing in common with the "classic" Toshibas.