Any double-din unit you get is going to look pretty much exactly like that Kenwood setup in the video you linked. Mine has that exact same bezel, it's just flipped so the narrower part is across the top instead of the bottom. I originally had it oriented like the Kenwood, but I think it looks better reversed.
I have had an AppRadio 2 installed for several months now. It was cheap with the rebate (effectively $280), but the functionality out of the box was actually really disappointing to me. First of all, you have to plug the phone in, then click through approximately 237 warning screens just to get to the apps screen (not really, but it seems like that). If you're using an iPhone, then you will be limited to full-functionality of Pioneer-approved apps (there's a list on their site). I listen to music almost exclusively by streaming it through Spotify, which isn't an Pioneer supported app. So, I decided to jailbreak my iPhone 4S and install AppRadio Extensions, which is a VERY cool Cydia tweak that essentially allows full mirroring of your phone's screen to the AppRadio. Here's a good video showing how it works:
Pioneer App Radio 2 & iPhone 4 Jailbreak - YouTube
If you run an Android phone, you're in luck, because there is an app called ARLiberator available which obviously doesn't require a jailbreak. Since I don't have an Android phone I'm not sure about its full capabilities, but it seems to do everything that AppRadio Extensions does (and maybe even more).
If you're wanting the dash to look as close to factory as possible and you still want to upgrade the factory system, then you might as well forget about anything but a Dynavin (or Eonon). Since I've never played around with a Dynavin, I can't say whether it would be better than an AppRadio (or another similar touchscreen double-din). But it probably doesn't offer quite the same flexibility that the AppRadio does.