I've had, and have, many canoes, Kayaks and a few SUP's. Current inventory is 14'4" Wenonah Vagabond solo canoe, Native Ultimate 12 Elite kayak, and an old beater Riviera SUP. A lot is about weight for me at 73 and I carry them on the roof of my Honda Civic.
Weights, SUP 34 pounds, Canoe 38 pounds, and Kayak is 40 pounds.
Paddling 1st choice is the canoe, its made to paddle but very sketchy for standing. Its very light, kevlar, easy to load or hump to/from water car. Floats in spit and can get over the skinniest of flats.
I Had for many years a 14' Mohawk canoe about 75 pounds, tandem, it was good for paddling and standing, but had a helper son to help with the loading part. Also had a 12' INdian River Otter for a few yeasr, also about 70 pounds, better for standing and poling than paddling but great for the flats.
Old Town make some pretty nice canoe now with fisherman in mind.
For stand up fishing I go back and forth on the SUP or the kayak. I like the SUP its light, easy to handle, easy to paddle standing or sitting on a cooler as well as standing using a 12-14' push pole.
The Native Ultimate has a comfy seat but seat is low to water unlike the more modern heavy wide kayaks available today, its much lighter, easy to load and hump to/from. This kayak is very easy to stand and paddle or pole, it paddles very well, I think an ideal all purpose kayak is the Native Ultimate 14, no longer made but can be found if patient on the open market.. they weigh about 50 pounds, can be found in solo or tandem, and tandems that easily convert to solo by relocating one seat and removing the other They paddle well, track straight better than the 12, easy to stand and sight fish, and not overly heavy when handling. Kayaks like Canoes also have the advantage in skinnier water due to most SUP's having some sort of fin for tracking.
Canoes and Kayaks are pretty easy to load/unload and carry in a PU as you want, with one of those T bar bed extenders. My son had some Thule racks that mounted on the bed rails of his F150 , they raised and lowered easily and carried his kayak extehde over his cab rather than out the back of the bed.
SUP's are great for Stand up fishing, stealth, paddle pretty ok when standing, or using a push pole., some have lawn type chair, or Larry chair, for sitting, or you can have a cooler to sit on. To sit and stand you will need either 2 different paddles or an adjustable paddle. I use an adjustable paddle but they are heavier than non adjustable. Most SUP's paddle OK, so ling as it's not windy.
I also had a DragonFly 13'6" which was a very good SUP for Standup Sight Fishing, weighs about 55 pounds. THis model is built by boat builders, same process 2 piece mold vacuum infused gel/glass, designed with Fly fishing in mind. It paddles very well has a V bow like a skiff so it paddle well in about any wind. They offer an optional shallow water fin, that is about 4" deep so it can get pretty skinny but not as shallow as the canoe or kayak.
Another great design is the Live WaterSports SUP's, Ge;coat/Fiberglass, cat type hull, paddle or pole very well, get pretty shallow, in the mid 50 pound range, lots of flat deck space.
Hard shell SUP's tend to me more delicate that kayaks or canoes.
There are a few hybrids kayak/sup designs today on the markey, one mentioed in prev. post, that are poly-plastic, on the heavier side. These paddle of=k, many don't have a fin so they get as shallow as a kayak, and have the lawn chair type seat.
I spend 90% of my paddling time on shallow flats or in mangrove creeks and tunnels, where pedal powered craft struggle to get so I can't speak to them.