Want some advice for camera choices.
Interested in lighter weight, and self contained--meaning not an interchangeable lens camera.
Would wear around neck while paddling, so want a camera that can get wet and possibly, but hopefully not, fall into the drink.
I DO NOT like the idea of using my mobile phone's camera while in the canoe. It stays safely bundled away way down in a pack until the drive home.

Here is one possibility:
Ricoh WG-70

DP Review list of waterproof cameras for 2021

This is my favorite info source on cameras. Includes a slightly older Rico that Ausable mentions.

butthead

I used to carry a Panasonic Lumix which was a fantastic waterproof camera, even used to take it snorkeling down to 20' or more and no issues, but nowadays I actually have been using waterproof phones from Amazon for the last 3 years and have been using them as a combo camera, GPS, and phone which saves me some weight and bulk (plus it's always in my pocket).

Last one I had held up really well and I wasn't easy on it. Used it for mountaineering trips in the PNW, caving in Coldwater Cave in Iowa (was submerged for a few hours), many times for navigating while hunting and backpacking in the rain. Sat in my kayak stowage many times where it got wet. It finally bit the dust (kind of) this year when I forgot it was in my pocket when I was swimming in Johnson Falls. Pretty sure I had it near the bottom of the big pool (roughly 7/8 feet) which was past its' IPX7 rating. The camera lens got some moisture in it and the camera stopped working, but everything else still functions fine. Bought a new one and pretty confident it's as good or better.

Until I had that phone I was never convinced I would be able to rely on my phone as much as a dedicated GPS like my Garmin. Now the Garmin collects dust and so does the camera.

I have used a Canon waterproof point and shoot. I'm not sure what your budget is, but the D30 would be what I would buy to replace the one I have now.

Canon Powershot D30

I have long carried an Olympus Tough point and shoot camera. It has held up very well and with two rechargeable batteries, easily gets me through a 2 week trip.

deerfoot: "I have long carried an Olympus Tough point and shoot camera. It has held up very well and with two rechargeable batteries, easily gets me through a 2 week triqtp."

+1 on the Tough. My only complaint is the viewer on the water can be difficult to see properly. Lots of good advice. Enjoy the shopping,

I've had good luck the last 5+ years using the Fujifilm FinePix camera that is on the list that Butthead provided. It fits nicely in a shirt pocket for ease when paddling or for a quick fish picture. The picture quality is good for a point and shoot. I carry a couple spare batteries after I run out of power with one battery on a 6 day trip.

My kid got a Fuji shock/waterproof camera a few years ago as a birthday present..... We had to have it warranty replaced within a few months (in the middle of summer camp) because it started malfunctioning. The replacement lasted a year before the lens motor started randomly misbehaving and started introducing a violent shaking into any photo or video we took (plus sound like grinding gears).

I mostly use a waterproof pouch for my phone. It has a lanyard and is secured to my PFD, and lives in a pocket in my vest when not taking photos.
My cell phone also takes incredible night photos (thanks Google!) on a tripod.

I use a Nikon Coolpix W300. used it Antarctica to the Noatak. Tough enough to put in your Lifejacket pocket, and still get good photos. Only negative issue is the proprietary batteries/ USB changing.

Been using the Olympus tough for years with no complaints.

I have used a FUJIFILM XP for years. It has been waterproof for me during that time (rain). It has a rechargeable/removable battery, takes standard sized SD cards, good zoom, good quality pictures. It is listed as shock proof, but luckily, I have not tested this feature. It is not too big.
The one negative, which is a personal preference, is it does not have a viewfinder. The screen can be hard to see on sunny days, and I am used to using one.