Option 1 is to get an Epson Perfection series flatbed scanner. V800 or V850. This approach is highly automated and you get automatic dust correction with color film. But, leading software packages don't support Linux, and the quality for 35mm negatives is just okay. Performance on medium and large format is SOTA.
Option 2 is to assemble a scanning rig with a DSLR and a light table. This approach is fiddly and requires a lot of space, but with some tuning, the 35mm scan quality can beat flatbeds.
There are some other, more obscure approaches, like vintage Minolta and Nikon scanners, but unless you have a PC with a parallel port laying around, you're gonna have a hell of a time getting those working.
None of these options are good, and if this thing can really perform, I'd happily drop $500+ on it.
Side note: Those little toy scanners like the Kodak branded ones on Amazon are atrocious. Avoid them. If you need to scan some family photos and you don't want to break the bank, go to your local photography store. They could really use your business.