Did you find a new home yet? I agree with many others - Michigan can be crowded during July/August. A lot of people vacation here from all over so the popular spots are good to avoid during prime time. I believe, like anywhere else, there are many more hidden gems than popular spots that you learn about over time where you can still find solitude. Lived here most of my life other than a couple years in WI. I lived in southern MI for a few years for work but really like the middle of the state where I am from and now reside. Pretty much 2 hrs to anywhere in the L.P., 2 hrs to the bridge, ~3hrs to lake superior or Sault St. Marie Canada. There are many canoeing opportunities, as well as some of the best fishing around and pretty good hunting. Outside of the hottest 6-8 weeks of the summer, most places are pretty low traffic. Then again, maybe I have just learned to avoid the crowds! There are stretches of the popular rivers that are really crowded during prime summer season, but not the entire system. Just avoid the main runs the rental/outfitter places service and you will be fine. I have done several summertime weekend trips on the uber-popular rivers like the Manistee and Muskegon in the L.P. and not run into others or maybe see 1-2 groups that never bothered me. Most canoe folks (even the kayakers) you run in to on the sections the outfitters don't service are good people. The college kid party crowd types stick to the day trip sections close to the rental places. There are a few wilderness areas and Canada is close as well. Not sure if we have any one spectacular spot everyone needs to see, just a whole bunch of really solid and beautiful opportunities. Houses are relatively affordable if you get a couple hours outside the bigger metro areas as well.
That said, I would probably choose to live closer to family (well, if you like your family that is) since you have kids. I have heard WV is a great place for outdoor lovers. You will have grandparents nearby to watch kids, family get togethers and holidays, maybe a few childhood friends in the area. In my opinion you can find fun canoeing just about anywhere there is water if you really love to canoe. If your kids and wife are into canoeing the family vacations can always revolve around that. If not, you likely won't get much free time away from the family anyway until the kids are out of the house no matter where you live. BUT, maybe you can send the wife and kids over to her parents' house to visit if they are close by and you can sneak away for a few hours to paddle! Get the kids in scouts and volunteer to help plan and participate in the campouts; I did a ton of canoeing, lake and river trips, with the scout troop. I'd say pick a spot where the grandparents can get involved with the kids while they (both grandparents and the kids) are still around and make some great memories. Find the local gems in the area where you can sneak away for a weekend here and there when time and the family allows and plan a couple bigger trips each year where you can experience what the rest of the country has to offer. Being a remote worker you can even work camp and spend a few weeks here and there exploring if you get that RV. The wife and I are both remote workers and have done some month long work camping excursions just to experience new areas. It is even easier now with starlink mobile. I can tell you from experience, just because you live near a bunch of great locations doesn't necessarily mean life will allow you time to get out as much as you would like. Now, if you don't like her and your parents/family, disregard everything I said, buy an RV and let the adventure begin! You will find the perfect spot to settle down after a bit of exploring...