I used to canoe a bunch, and ran a ton of trotlines from them. We ran a few rivers that were up, but mainly preferred the later season calm with cleaner water (and therefore better tasting catfish that have already spawned to maintain populations). Never tried the kayak, but the right canoe can be a very capable boat. It was my dad's, and is a relatively heavy riveted aluminum. We used to simply paddle because we were young but plenty of guys around here run around with trolling motors on the square transom. Ran that way they can pretty much go anywhere and do it fast and silent, carrying quite the load making them even more stable.
It's usually best to kneel for the lower center of gravity and back position, but this can be hard on some people's knees/ back so that might be a consideration too. When they got coolers and gear loading them down you can safely sit on calmer waters, but any quicker spots or spots where you might bump a log it's safer to be kneeling.
Some of my happiest memories growing up were on the water with my family, so I'm hoping to get the sailboat going this spring to start it with mine. If you're by big water like that you might be surprised at the price of a used sailboat, i got my 25 foot macgregor 25 for 3500 bucks with a trailer and it's been a blast. I haven't had it out in a few years but it'll clean up just fine, and there's nothing like a boat under sail. The flushing toilet really makes getting away much more enjoyable too. That's when convincing people to do a weekend trip becomes a great idea for everybody, so it's more likely to happen in my experience.