I had a Nikon D80 DSLR for about 11 years...it served me well.
Last year, I bought a used Nikon D7200 body with 125 shutter actuations on it. I'm extremely pleased with it, it's quite a step up from my old D80 in all respects, image quality, battery life, ISO range. And yes, it does work at 0 degrees F.
It does still weigh the same 3.5 lbs with an 18-200 zoom on it, but I would rather leave some food home than not carry my camera. It is also bulky, but I would rather leave my sleeping bag home than not carry my camera.
In all the years with my D80, and over a year with this D7200, I have never gotten either of them wet enough to damage them. My camera is always in the canoe, in all weather and water conditions. The only time I'm concerned about it getting wet is while sailing, where I tuck it in a hatch. Never bothered to use a dry bag, and certainly not a case, any protection would take too long to get the camera out, and those bald eagles rarely sit still and pose for me!
BTW, I only converted from transparency film in 2003. I used to use a Nikon FM, and before that, a Pentax MX, both were all manual, all mechanical bodies that never failed in any weather.
These DSLR's are pretty close to those old film cameras in their feel and use.
Edit:
Sensor size for the D7200 is 23.5 x 15.6 mm
YC's HS 70 SX has a sensor size of 4.55x6.17mm
Depending on what you plan to do with your images, a tiny sensor might be OK, might not
Also consider shutter delay, very common in P & S cameras but non existent in true DSLR's
And wait, there's more!! What about interchangeable lenses? Most modern DSLR's will accept any compatible legacy glass that you might have, maintaining full original capabilities