Just got my TP2 last week, and some apps I've already found. All my links are at home, so just google the app names.
Music detection
Midomi (I've tried and works)
Shazam (paid app through winmo Marketplace. Haven't tried)
Changescreen - gets the accelerometer working for everything, even Sense so you can use in landscape with the keyboard closed.
Barcode checking
Barcorama - you can take a snapshot of the barcode. It searches on google, though I think you can send it to other sites. Kinda touchy, but fun to play with.
FastPriceCheck - a website. You can download an app. You can manually type in a UPC and it'll search some shopping sites.
G-Trigger - shake your phone to perform functions or start aps.
Tele-Sketsa - Draw on the screen with your finger or stylus. Can then send to someone as a MMS.
ShootMe! - Sound effects tied to the accelerometer. Crack a whip. Wield a lightsaber. Shoot a gun. etc.
Navicomputer - downloads open source maps to your phone that can be used offline. It doesn't give turn by turn instructions, but can be used to create paths and trails.
If you really want an iPhone style app, I ran across a paid fart app out there, but didn't bother download.