Welcome Will.
I did much the same you are suggesting.
We lived in the capital city in Ohio, Columbus, for 20 years. Way to big and lots and lots of traffic. Nice boating places were way over crowded. Opportunity to move with our jobs back close to where our families live on the Ohio river. We looked and looked and finally found a piece of property with 1100 feet of river frontage, but it was 3/4 mile from the road, no house on it. 48l.7 acres. So we bought, built our house and made trails and a river lot and never looked back. We have since retired and this is the perfect place for us. We love it.
I wish you luck in finding something similar. There is so many beautiful places and so much water in Canada that I have no doubt you can succeed in this venture. Good luck and do keep us posted.