For its price range, the Nikon D90 is the single best solution currently in the market. Between Canon and Nikon, I prefer Nikon's glass, ergonomics and on-camera controls.
The Nikon D90 has a video capability, but like all DSLRs, its rolling shutter produces a horrendous "jello" artifact, so...