Canon EOS 50D 15.1MP Digital SLR Camera with EF 28-135mm f/3.5-5.6 IS USM Standard Zoom Lens
I have had my 50D for a little over 6 months now. I have no regrets whatsoever. I love the layout, the size, the capabilities. The kit lens works well enough for me until I have the cash for some fancy Canon "L" lenses.
I primarily chose this camera over other brands or even over the rebel T1i due to it's size. I have large hands and many other cameras felt awkwardly small to me. This one fit just fine. I also like that it has a little weight to it as it just feels more solid than the light weight plastic body cameras.
It does not have video but I really don't miss it. Right now I am busy learning about taking great photographs. If I ever master that maybe I'll upgrade to a new one that has it in the future.
If you are just a parent wanting to snap pictures of children or vacations then I would say this is probably overkill. If you are wanting to study photography as a hobby or even a profession then this camera is a good choice that should give you many years of use.