It's been some time since I scanned slides, but I agree that Provia was one of the nicest films to do, Velvia 50 one of the hardest. Sensia, the less carefully made amateur equivalent to Provia, scanned nicely too.
I always had a perverse fondness for Velvia 100F, which many people hate for its poor rendition of bright colors. I liked the way it did earth tones. Good stuff if you spend a lot of time looking down!
I loved slides, but don't much miss the tediousness of scanning.
I'm obviously not a color conoisseur anyway, but I was not hugely impressed by the Kodachrome presets in the link below, but with the change in EV and white balance added, it's hard to tell what part the Kodachrome preset is playing, as the thing one notices first is the change in exposure.