DSLR Advice, Por Favor!

I recently acquired a roommate, which added a new cat to my household and cut my monthly rent check in half. SCORE ON BOTH! Now I can finally afford a few things I've been lusting after for the past year, like maybe a vacation and some new shoes. But seriously... since my birthday is right around the corner, I think I'm finally going to treat myself to a digital SLR. Since 2004 I've survived on a Nikon Coolpix 5200 (as in 5.2 humiliating megapixels), and even though the little guy's always been good to me, my reputation demands an upgrade... especially since the battery door hinge fell apart in Cambodia and I was forced to wrap half the camera in duct tape. Hot. And sticky.

So I ask all of my informed, photographically inclined readers: What's the best mid-range DSLR out there?

I'm already eyeing the Nikon D90 for a couple of reasons: I've already got a decent lens from a Nikon SLR that I can swap in, and the HD video function is a huge plus. I'm also one of those lifelong Nikon enthusiasts and it would feel good to stay loyal, even though some of my friends SWEAR that Canons are better cameras overall.

All feedback is appreciated. This is obviously going to be an expensive purchase, and I want to be sure I'm doing the right thing before I pull the shutter. HEE HAW! Thanks in advance.