I get very acceptable results from a Mustek 12000p scanner with transparency adapter from 5 x 4, and useable results from medium format. However, if I was in the market for a scanner now, I'd go for the Epson Perfection 1200photo. I've seen really good results from it.

Of course, if money's no object Nikon's LS4500 is very nice.