High quality slide/film scanners are not only better able to provide better resolution, they also use ICE or a comparable surface scan to eliminate dust from the digitized image. High res Scans of B/W negatives tend to show the silver halide grains, and there is software available to counter that as well. My scanner is not new - it is an Epson 3170 with 3200x6400 ppi. In my estimation, 35 mm scans were a little better than mediocre. For the few slides I periodically scan, I use a digital camera with closeup lens attachements, an xray viewer light box, and a copy stand to standardize distance and placement. By filling the camera frame with the slide content I get the resolution of the camera and the speed of a shutter click rather than the slow scan at highest scanning resolution. If your camera has a suitable macro setting that will work well, but many of the macro settings on consumer grade cameras function at the wide angle setting which can create barrel distortion. Using some old darkroom tools - a small squeeze bulb air blower and an anti-static brush I've used for cleaning negatives - i eliminate nearly all dust and foreign material prior to digitizing the image.
I've done medical/dental photography and know that direct, shadowless light sources (like a scanner light source) eliminate texture. I originally used ringlight flash units but found that a single flash off the axis of the lens provided texture detail that was lost with the shadowless ringlight. I also used electricians tape over sections of the ringlight to pick up the shadows that show texture. Try crosslighting a textured paper and photographing it to see if the result is to your satisfaction.
I've done medical/dental photography and know that direct, shadowless light sources (like a scanner light source) eliminate texture. I originally used ringlight flash units but found that a single flash off the axis of the lens provided texture detail that was lost with the shadowless ringlight. I also used electricians tape over sections of the ringlight to pick up the shadows that show texture. Try crosslighting a textured paper and photographing it to see if the result is to your satisfaction.