[General Questions and Answers] Valkillmore:
I would think in order to get a decent response, you would want to narrow down what it is you are looking to do.

If you can think of it, it has an app. If it doesn't......start learning how to design apps and make some coin ;)

But here goes with a few of my faves............

AudioGalaxy

For portable music from my HDD. Full access to my home music collection.

The best app in my opinion is AudioGalaxy. It has magic metadata that somehow seems to get all names and artwork right. It ports into your personal collection and can be streamed over data or wifi. You can make playlists on the go that store in a folder on your PC at home. It is simply amazing, and with even just a decent signal, it streams virtually flawlessly.

I can't say enough about it, other than GET IT !!

To top it all off, it is 100 % free. But I found it so good that I actually bought the add ons just to support the development of the app.

Hands down my favorite music app, and in the top 5 of my all time apps.

AirDroid

Wifi transfer your media/files from or to your Android device and PC. Uses your browser and has a cool interface that you can shuffle around like a desktop. Hasn't dropped a transfer yet. Free. Very cool app.

WiFi Explorer PRO

Same as Airdroid pretty much. Works awesome. Great support. I bought this before I found AirDroid. Both are great and transfer fairly fast for WiFi. Interfaces thru browser as well. Very good app.

ES File Explorer

Hands down my favorite file management app. Transfer files between phone/home windows shares/ftp server/bluetooth shares/online storage drives.

One of the most popular on the market. Somewhat customizable. Plain and simple it is THE file managment app in my opinion.

Tablet Talk

This app allows your non-3G/data enabled tablet (wifi only), to link via wifi or bluetooth to your data/wifi smartphone.

If you have your cell phone charging in another room and on, you can connect your tablet to it, and you can then text or call from it using your data/contract plan.

Very cool app. Comes in handy in various situations.

iMediaShare

VERY cool app !! this app acts as both a server or a client on your network. It can pick up other dlna/upnp servers, and connect as a client. Or it can act as a server, porting various media shares/local files to a specified device like a PS3 or a 360.

What is REALLY cool, is that you can web stream various websites, like YouTube or HD Nation by browsing the site on the app, finding the vid/s you want, and point it to the PS3. You then go to you media server section on your PS3 or 360, and voila, that video is onscreen.

You can search YouTube, and then view the whole search query. As well, on the PS3 you can copy these vids to your HDD.

What is truly amazing is the amount of web sites to choose from.

Motorz HD

Vimeo

Revision HD

YouTube

The White House channel

Nasa

TED

CBS

....and the list goes on and on and is growing all the time.

You can stick with the free (lite) version which has 80% available and standard definition video. If you pay the 2 bucks or whatever for the full version, you can access a few more channels but you get the HD channels as well.

I have a whack of HD music vids from YouTube, stored on my PS3 now because of the ease of this app. Simply awesome !!!!

OverSkreen

The coolest browser on the market ! It'a a floating browser. (I would link you to my YouTube clip on it, but I am still a noob so unfortunately I can't link you any of these and you have to Google them yourself)

Anyways, back on track.

Overskreen floats on your desktop to give you a windows effect. You can run one app, and have your Overskreen window tucked in the corner watching a mini youtube vid. Hard to describe, I suggest checking it out.

Very innovative. The app is getting better everyday, but is still new so it has some bugs. Either way, it may change the future of smartphones and tablets. Check it out.

Games

GTA III - no need for explanation. Only game I have. Pretty sweet. Costs a few bucks but worth it.

Wallpaper

Jumpgate - simply one of the best wallpapers for your Android . Burns your battery a little more, but it's definitely cool.

So there's a few for you. Not sure if you are looking for something else, but these are some of the most used and actually useful apps in my inventory.

I can add to this later as I think of more.

BUT........

If you really want to have fun and tinker. Custom ROM's is where it's at.

My Telus Mobility Nexus now has a lockscreen carrier name of:

Smell-us Slo-bility

...and my opening boot animation is the little Androids on the the Tron bikes that collide in an X shape and explode into the Galaxy Nexus logo.

Good luck. You've dived into a world of fun simply by picking Android.