The installed apps are pretty good and the connectivity is awesome. This is a truly great unit. The asteroid market is getting better all the time, but I dont think you'll be seeing any google apps in there which is a major limitation.
The included GPS software is rubbish in my opinion, if you're used to Google Navigation.
That's where side-loading comes in. If you sideload it with Google maps and streetview (and a bunch of other apps while youre there, like trip advisor and 8-tracks) it becomes a truly great unit. The bluetooth tethering works flawlessly for me, so that every time I get in the car it auto connects to the web in under a minute.