I have a wide screen monitor with built in picture in picture. It was $600 and is very cool. I'm seeing more and more of these LCD monitors with that built in.
The only issue I have with Tuner cards is that the PC takes a performance hit. I've been using them for years but I DID drool over an ATI HD tuner card I got a couple years ago. Looked fantastic.
I don't know anything about this other stuff.