Huh, I've had this thread open all day, but I never got around to posting in it (got a little distracted by lunch... and Lock, Stock and Two Smoking Barrels... then dinner) but just as I'm about to post, it appears that the DSLR has to wait!
I'll post anyway, since I've been through (what is to me) a plethora of Nikon DSLRS!
If it's truly auto everything you want and you could care less about features, high ISO, or fancy lenses, maybe a D3100 is the way to go. It's cheap (around $600 for the body and a 18-55 kit lens), small, and has a decent sensor (the one they put into DX nikons before the 5100 and 7000 I believe, I'll look into it later).
My friend has the D5100, and while it's got that beautiful sensor, it's got a similar menu layout to the D3100, and to be honest... I don't think it's worth the price. Again, if price is really an issue, you want an auto camera, and lenses and image quality aren't important to you, then the 3100 offers you most bang for your buck. It's got a good sensor (just two megapixels less than the 5100/7000 sensor, and can still handle low light well), a nice auto mode, comes with a decent kit lens for a price that's less than the 5100 body only.
I've also owned a D200 and a D60... they're both nice cameras if you're not too picky about low light performance. The D60 is pretty much an old generation D3100, loaded with beginner features and a complicated menu layout. The D200 was one of my favourite bodies; rugged, had a motor, supported Nikon CLS, decent sensor.
I currently only have the D7000 left, and I used to love it alot. It's a great camera, great sensor, everything a crop-frame user could hope for. Definitely the way to go if you've got money to spend and want a nice all around crop-frame camera. The only reason why I've stopped using it is because I find DSLRs to be too big to carry everyday now that I've got the Fuji X100.
Ontop of all that, I've shot with my friend's D90 for a bit. I can't really complain about it. It's an old generation D7000 that'll still please you today.
Anyway, to conclude... seems like for what you want (auto everything, daytime camera, a simple alternate camera for when you don't wanna use rangefinders, correct me if I'm wrong) the D3100 is the way to go. Good low light performance, cheap, small. The 18-55 kit lens isn't horrible either.
If you want something more, then I'd say... you can't go wrong with a D7000 or D90. The D7000 to me is better than any other crop frame nikon I've used, and the D90 isn't far behind.
I've been thinking of selling my D7000 + Battery Grip lately. Let me know if you're interested!
Also, where do you get your CV lenses in Canada?