Most of my 35mm flickr stuff is dslr scanned:
http://flickr.com/mdarnton The most recent three are with my D7200 (4000x6000, roughly), the rest with D300 (2800x4200, roughly), and only one, the 4th, with a G4050 HP flatbed, just to see what it would do in its two-pass mode, compared with camera scanning.
I recently upgraded to a Nikon D7200 (24Mp, no anti-alias) and an El-Nikkor 63mm/2.8, with a bellows/slide duping rig, and the results are literally more than twice as good as I was getting with my D300 (12Mp plus AA) and 55mm/3.5 micro-Nikkor. But I was happy enough with the D300, which edged out flatbed scanners. Now I'm delighted. The latest (plastic mount version!) 63/2.8 Nikkor is supposedly one of the very best lenses out there for this job, along with the 75mm Rodagon-D lens which is harder to find and more money.
I don't do any color, though, so my things may not help you much.
You may get the wrong impression a bit, because the D300's resolution range is particularly vulnerable to grain aliasing, which makes "false grain", larger than the film's own grain. That's not grain sharpness you're looking at there. The D720 scans are, I think, real grain, resolved. . . or closer to it, anyway.
I would put it this way: if you are satisfied with the resolution level of your Canon DSLR, with a little care and the right lens you should be able to drag that much out of film, if it's there. Since my habitual Tri-X in D76 has less than my 24Mp DSLR, I'm completely happy with what I'm getting, and there's nothing more to get.