As seen on Stargate
I am a fan of Sci-fi series Stargate SG-1 and Atlantis and they use some pretty cool gadgets that are actual consumer computing products. The Dell desktop and laptops are a common sight as well as other more futuristic gadgets. The Tapwave Zodiac featured on a few of the series was one reason I got one. The latest SG-1 episode even has a pair of Zodiacs used to store the cure for the Prior plague (see screen cap).
Another neat product is Motion Computing's Tablet PCs. I have yet to see any of these in the local retail shops and they look gorgeous. Its featured in Stargate Atlantis and is often seen used by Dr McKay in tablet form within a bump case. Its also found in its desktop dock with keyboard in Dr Weir's office.