Originally Posted by
Maverick
My favorite apps so far are Google Maps, Google Places, Weatherbug Elite and NewsRob for RSS feeds. Google Sky Map is fun to play with, as is GPS Status and the Google Goggles beta.
ES File Explorer has a lot of nice features in addition to being a file manager, like the ability to browse your local network (via WiFi) and has now added FTP as well.
I use CurveFish's widgets for WiFi On/Off, Bluetooth On/Off, 2G 3G On/Off (when I'm not browsing the web or downloading apps, switching to 2G-only saves tons of battery), and Brightness Level. They're just shortcuts so I don't have to dig through the settings menu to toggle them on and off.
I'm not sure how good the web browser is on the Hero, but the default one on mine sucks, so I use Dolphin Browser, but I'm also awaiting the release of Fennec, which is shaping up to be much, much better than any other mobile browser on the market.
There's a mobile version of Photoshop that gives you limited photo editing functions, Wapedia for Wikipedia articles, Amazon.com has an app, and there are many apps for tracking exercise and weight loss, if you're into that sort of thing. Usually about once a week I'll just browse the Market just to see what's there.
A hearty second to the info Miatamaniac gave you. There's dozens of Android-centric websites which all have their own recommendations, but the Gizmodo list covers most of the best apps out there.