Dypsis, in many ways I am where you are. I am looking for a canoe or kayak to stand and fish in, be somewhat lighter weight, use my troll motor with and can carry two (mostly me alone though). It has been an in-depth search but I have narrowed the search to:
1, Canoe with outriggers. Many canoe choices but I believe out riggers will end tipping over discussion. I am looking at the Wenonah Tandem Fisherman canoe which is really wide and gives a lot of room, but pricy. I would use outriggers with this canoe also. A lot of less expensive canoe options. If you want to take both kids a larger canoe is probably only option.
2. KC12 Fishing Kayak. This is really a cross between a canoe and kayak but can carry two and is super stable with large deck to walk and fish standing up from. Negative is not best paddling craft but I don't plan on far water trips, plus trolling motor will negate this.
Kayaks that can hold two and you can fish from get way to heavy. The KC is 46 lbs.
Weight is a big issue but I discovered Rhino Side Loaders or rear T-Loader that will make loading on my SUV much much easier for one person. I was told by kayak retailer today that when you pick up a kayak/canoe with one end stationary on ground, rule of thumb is you are picking up 40% weight of craft.
When experimenting picking up craft today I noticed that the smoothness of the hull made it more difficult because nowhere really to grab from, even if weight manageable.
Good luck, lots of choices and difficult to pick one. One final thought of mine is to pick up cheaper canoe with outriggers to use when with another (Wife, son or daughter) and get a solo kayak for me alone?