Well, let's see:

MMS - coming through the community (fMMS)
Personalised ringtones - coming via the community (tweakr)
Custom profiles - coming via the community (shepherd)
More games - coming via the community (sheep!!)

Rereading the first post it seems to me the problem the OP is having is with the rather empty shelves of the Ovi store, and not anything to do with n900 at all - "Loaded with apps"? But n900 was never advertised as having 'loads of apps' because it's a new platform. Of course, Maemo 6 will be back to square one mostly, for apps, except for those Maemo 5 app written in Qt and portable.