I’m not too sure what I think about this one just yet – so I’ll let the above demo video and Scott’s hands on photos do most of the talking until I get a chance to prod at it myself. From what I can tell from pictures and specs alone, however, I’m a bit disappointed at the lack of a dedicated row of number keys (likely sacrificed to allow the screen tiltage). I’m also a bit wary of the resistive touchscreen, having been spoiled by a few amazing capacitive screens as of late.

I agree… I think its hard to decide on ANY half decent phone before you have a couple hours to play with it. My initial reaction is that the hardware is better than the G1 and might match the iPhone but Android and MacOS still have a leg up with the development community making more of an immediate impact.
For people searching high and low for N97 stuff and coming up with the same info, nice little organized resource here: http://nokian97.org