I had a very brief go on one today. The 3d effect was excellent, although you don't get it from looking over someone's shoulder, you have to be the one holding it.
The guy in the shop (not the Nintendo guy with the 3DS) said it lasted about
seven hours yesterday without needing recharging. They
had full 3d on all day, so make of that what you will.
I want one.