Droiddog and Phonedog have both done extensive hands-on videos of the Hero in action. Phonedog has a great 3-part video of a dogfight between the iPhone 3gs and the Hero, and while I don't think the two are really comparable, it goes into great detail showing you all of the amazing features and functionality of the Hero. Droiddog has done a bunch of "Hero Questions" videos that is basically a 5-part video series addressing user submitted questions for the Hero. He's also done some browser vids and a camera vid.
Now, I'm biased towards the Hero, so I don't really want to suggest which to buy. I do encourage you check out the videos I've linked. I've watched many videos on the Touch Pro 2, as well and own an Imagio (temp until Verizon's new Android phones hit the market). If you've seen one video for the Touch Pro 2, you've pretty much seen them all.
I'm just linking the Droiddog/Phonedog channels as I'd have way too many links in here otherwise. Enjoy!
http://www.youtube.com/user/droiddog
http://www.youtube.com/user/phonedog