I agree with Barts about being "on hold" if you wait for the perfect product. I too am mostly a regular user/consumer who was looking for an upgrade from the my previous non-smart cell phones that were very very bad at almost everything except the phone features. But I'm also a software developer who can appreciate the advantages of a command line interface and a device that isn't crippled by a cell carrier.

My generally feeling on the N900: awesome hardware, awesome OS, but some apps are missing (e.g. a good countdown timer), some apps are pretty rough (e.g. the Ovi Maps app is not Nokia's latest best version for whatever reason) and some apps are still buggy. Of course, apps will be written, polished up and fixed over time. I would say the N900 is still in the "early adopter/geek" stage and the really average consumer might be advised to hold off for 6 months.