I hope it does, not the stupid apps, but the useful ones.

Some points of comparison. Im comparing my G1 to the N900.
Multi-tasking
Has multi-tasking but when you switch between apps you have to wait for web pages to load. When on the N900 you can switch between apps and no loading at all.
Browsing
N900 browser is beautiful, renders everything perfect and the flash is awesome. The only thing that I think the android browser does better is fit the text. I know about the re flow but it doesn't work every time.
Media
Video support is far superior on the N900 than on the G1. The audio quality is about the same. Media players have about the same functionality.
Email
Both of them have about the same functionality.
Phone
No big difference.
Apps
Obviously the G1 has more but im not worried about that.
Quick settings.
I love how easy it is to access the WIFI/bluetooth/etc on the N900.
On the G1/android you either have widgets or you have to go through the settings.

One thing is do really miss is using my phone with one hand. I miss portrait mode. But I am excited to see the N900 get some portrait support.