Based on my own experience, the biggest issue with scanning negatives and transparencies (slides) is dust. You really have to be careful and you often still have to go in and clean-up your images. Granted, there's options with most scanning software which can remove dust, but it could also impact some of the finer detail of your images. I prefer to just try and physically remove as much dust as possible and then use Photshop to do whatever clean-up is needed afterwards.
Note that I started to scan my negatives and slides in 2000 (my wife and I have been shooting photos since the early 60's) when I bought a CanoScan FS4000US film scanner. Initially, I used the Canon software on my Mac, but they've stopped supporting this scanner years ago. I now use the 'VueScan' software from Hamrick Software (
www.hamrick.com). It works great, with ALL of my scanner hardware, the CanoScan, my Epson flatbed scanner and the scanner on my all-in-one Epson printer.
My archive currently consists of over 56,000 images, of which some 18,000 were scanned from film (slides and negatives). The vast majority of these were 35mm stripes of negatives, mounted 35mm slides and APS cartridges, all of which were done using the CanoScan device. Now there's probably close to a thousand images scanned from larger negatives and transparencies, which were done using one of the flatbed scanners that I've had over the years. The rest of the images in my archive, some 38,000+, are from digital cameras.
Note that I started to shoot digital images in December 2000, but I was still using film for some time, shooting my last 35mm negatives in August 2006.
Also note that in addition to the actual archive, I've got a forms-based database built using FileMaker Pro, which includes not only a description of the image content, but also the date and place where the image was taken as well as the camera and lens, media type (film versus digital) and the names of any known individuals in the image. All of this data can be accessed via keyword searches. Also, each file record includes a thumbnail image.
Anyway, whether you shoot film and then scan, or just go pure digital, that's your choice, but if you do want to scan either current or legacy negatives/slides, please keep in mind that a little effort keeping the media clean will go a long way in reducing the work that you'll need to be put into this.