I have the Moto dock as well, (there are very few other options at this stage of the game) and it doesn't keep the screen on by default. You have to enable it in the settings, and the option is to "keep screen on when charging". That's specifically why I got Dockawake, because the droid only stays on in the dock because it's charging, not because it senses the dock magnets. That's also why it won't stay on with the moto car dock, since it doesn't charge it as well.
I didn't like the idea of my droid screen staying on all night every night and just running for no reason while it's charging, but I did want it to stay on while it was docked at my desk in the moto dock, which is why I got Dockawake.