A long while back I looked into film scanning as I bought a medium format camera and wanted to home process the negative and then scan instead of sending stuff away - however I've never got round to doing it (I really should!)
That said at the time Espon was highly recommended to me as a quality option for home scanning. Having a quick look on Amazon the Espon Perfection range would be a good range to start looking at in terms of prices and quality of product. The Epson Perfection V550 Photo Scanner might be what I'd consider affordable for this kind of work (at least compared to paying a company to do it for you); whilst producing a good quality result.
However you could go all the way up to the £500 and £700 options. The bonus is that once you're done you should in theory, be able to sell it on secondhand and recoup some of the cost.
The very cheap (sub £100 small name brand) options I think would be good enough for home snaps, but might not be all the way up to the quality you could be after.
The other option is if you've got a good camera, nacro lens and some lighting (flash and something to diffuse it - softbox etc...) then you can do it yourself.
There are some cheap "slide holders" or you can make one yourself. In this one above I was just playing around with the idea of it and was just holding the slide with my fingers. Fine for a one off but not what you want if you're doing loads and loads
This was done with a crop sensor camera, I forget but since film is fullframe and the dimensions are different, so I likely cropped some of it away in editing. If you had a fullframe DSLR and a macro lens you could get a cheap film holder and do it that way.
Other thoughts:
1) Backup Harddrive and Cloud. Yeah if you're going to digitize the collection keep a mind to backing it up too. Cloud is nice but a spare harddrive is also good. No need for SSD fastness, regular drives are good for this
2) Photoshop Lightroom. It's on Adobes monthly subscription system now (which if you get one of the photographer bundles comes with photoshop too). I recommend getting this as it will help you greatly. It's a photo library software package that is built to help you organise large volumes of photos. In addition its also got some very good editing features built right into it. Now the Espon scanners I noted above do come with their own editing software too and that likely also has features for helping with things like spots and scratches etc... (things that are in photoshop but not in lightroom). So the Espon might do all you need with the software in the price as well, so there is that to keep in mind.
Lightroom also lets you do batch work very easily (again the Espon software might do this too I don't know); so you can process large batches at once to the same settings, which if they are scanned in or otherwise taken with the same lighting and settings and such would mean that any repeat elements should be easy to batch fix.