I'd suggest trying to see movies of the Metroid Prime: Hunters demo.......... gamespot at least had some good movies of them from their tour of Nintendo's E3 booth.
It looks a LOT better in motion, and very smooth.
The Mario 64x4 demo in motion also looked beautiful.
And no, personally I'm not underwhelmed by the DS. From seeing all the movies and reading about some of the tech demos, etc. I am really excited about it and the potential for it. When I first heard about the DS, the two screens, etc. it sounded more like a gimmick to me, but getting to see the actual way games are working on it has me convinced it is a lot more than that.
And I think that it will be a great platform even for those developers who can't think of anything more than just to use one of the screens for a map or a playbook or whatever.