I had the USB issue on my first N900, then got a last of the true New N900s from NewEgg(also got burned by a Chinese "new" bad refurb brick). I used a sucession of Zaurus form 2001 to 2010 then moved up to a smartphone.

Lets see: real Linux, good camera, Sygic maps, boosted FM transmitter, FM receiver, USB host mode, cuteTube with music downloader, preenv and apkenv games, 720p video, double scud batteries, Palm inductive charge transplant, Overclocked video chip and CPU, swappolube, evopedia now with wikivoyage, chroot debian for regular linux apps, many apps specificaly for when internet is unavailable or when you only have a prepaid SIM card.
The N900 has the real app catalog rather than the 10k's of fart noise apps, online only web browser "apps", and expensive apps that still mine you for data like a chump.
The N900 is the last of the pirate hacker phones, the phone that an unsupervised lab at Nokia never should have been allowed to build and then release to the public. No wonder MSFT had to send a hit man to kill off Maemo and Nokia with it.
I dont know when we will see a dangerous phone like the N900 again, I just hope mine lasts a long time until a true sucessor dev phone with a solid build and every gadget and upgrade potential they can cram in appears.