I've found that for my specific setup (calibrated Epson V750-M Pro, Silverfast Ai Studio 6 with Chrome Space 100 profiles by Joe Holmes), for 120 anyways, the Kodak films scan slightly better Fuji. Two specific films which I've had very good results with are Portra 400VC and E100GX. Films I consistently have difficulty with are Fuji Pro 160C and Velvia 50. Color neg seems to scan better than B/W, and it has been my experience Tri-X scans better than TMax.
One thing I have learned is that it is critical your exposures are spot on, especially slide film. Even slightly underexposing slide film can make it difficult and in some cases impossible to get a decent scan. Deep shadow areas seem to be the most problematic.
I'm down on the family farm this weekend for the holiday and have borrowed a friend's Nikon FE2 which I've loaded with Ektar 100, so I'll let you know how that scans soon as I get it developed.
Above all else it's important to experiment with your specific hardware and software. Neither all scanners nor all scanning software is created equal, and having even a single point in your workflow out of sync can cause major headaches.
Hope this is helpful.