The main difference between pro film and consumer film is that pro film is produced to the intended ultimate color balance very accurately, and is then stored in the refrigerator or freezer to keep it there. Consumer film is produced with the expectation of some shelf life (typically six months), so the color you get partly depends on its age.
I have gotten truly outstanding results in 120 roll film from Fuji Reala, which is plain-old consumer print film. In fact, it's my favorite negative film for landscapes. For people, it's a bit ruddy, and I use NPS 160 or the like to tone things down a bit.
As far as scanning being better with negatives than slides, that depends on the scanner and how well one's workflow is managed. The notion that one is superior to the other usually reveals a problem in the workflow with one or the other. For example, which of the following was made using Velvia slide film, and which was made using cheap consumer Reala print film?
No fair peeking.
Negative film compresses the scene's range into a narrower range of densities on the film than slides do, so negatives are actually easier to scan without running out of dynamic range in the scanner. (That's a hint.)
Rick "whose scanner is well-profiled, and whose screen is accurately calibrated and profiled using a hardware colorimeter" Denney