I've just got my N900 and loving every minute so far (upgrade from an N95 8gb) so it's way too early for me to say.

I will be a bit disappointed if it's not upgradeable though. I suppose it really depends on what Maemo 6 actually adds.