I became the family photo and negative custodian a few years back. It was a mix of 126, 120, 110, APS, 35mm and various other formats. I bought a Plustek 8200i for the 35mm negatives and slides, which formed the majority of the collection, and an Epson V600 for the rest. I had to get some 3D printed holders for some of the odd sized negatives which was a pain back then but is far easier now.

I used (and still use ) the vuescan software as I found it easy to set up and I ended up with a fairly quick worflow. I scan the negatives at the highest resolution as TIFF and JPG and then upload downsized JPGs to Goolge albums for sharing with the family. The scanned images are stored on multiple hard drives and in the cloud. Negatives were stored in archival sheets in binders. Prints and the like went into acid free storage bags.

By far the hardest thing was to find the time and motivation to do all the scanning and all I can suggest there is to break it into manageable chunks and to work at your own pace. Oh and don't fall into the trap of post processing every image to perfection when you scan them in, you can do this or even rescan individual images later.