All the over the top apps are baked in on Ignite. Netflix, Prime, etc, but you have to use the Ignite interface to access them. This is either good, or bad, depending on how you like the interface. It's better for elderly people or tech illiterates, because they can say "dance moms on netflix" and it will come up without them ever having to know how to work Netflix.
It's annoying because you used to be able to buy PVRs outright and not pay a rental fee. They were very cheap refurbished or used, to the point that after less than a year of not paying a rental fee you'd be ahead.
Depending on your area, you might be able to get most of the channels you listed for free using an over-the-air antenna. You can potentially get CTV (NFL), CBC (NHL playoffs, HNIC), TVO, Global, and City and a few other channels via OTA. You can also buy an OTA PVR. Global and City are harder to get in Ottawa. If it turns out that your located in an area where you get all of the above, you can also consider spending a one time fee to get an actual proper outdoor antenna setup that can be fed into your different rooms with coaxial.
I don't think there is much reason to stick with one specific cable provider. You might be able to pull the "I'm going to cancel!" routine and get the best possible deal via Rogers or Bell, then just rinse and repeat when your promotional period is up. If you already have other over the top services like Netflix, and you can get a few of the channels you want with an over-the-air antenna, the only reason to stick with cable is hockey or sports. Because of how regional deals are structured with sports leagues, unless you're out of the territory of the team, there is no cheaper (legal) way to follow a specific sports team or watch specific sports that you want. With that said, if you just want to watch a few hours of sports a week and don't care about the specific team, there are games on both over the air, and some streaming services.
Cable is going to die as soon as the regional sports bubble collapses and/or streaming services get all the sports, along with their older user base all dying. Sports are the only non-negotiable reason for most people to get cable.