I think you already answered your own question.
Lots of good choices out there but I would start with Subaru Impreza and work my way down. Subarus are the cheapest AWD car choice out there with a MT. Sadly the larger Legacy has done away with them.
I'm not familiar with Ontario winters so you would be the better judge on how a FWD car would do there. I'd rather have an AWD for those conditions.
There are some CUVs with AWD such as a Jeep Renegade but they won't have the same sense of handling like a car.