High amount of loading (meaning a LOWER value resistor) will reduce the top end which means less "sparkle" and "air" on top and more perceived bass (because the tonal balance has shifted). I personally don't like anything less than about 125 ohms with any of the cartridges I've heard because too much of the top end is lopped off, and the very reason for having a high end MC cartridge is defeated.
While I like it pretty wide open, some loading may be necessary, as others have mentioned, to prevent RF interference. I helped a friend with a Hovland preamp which suffered from noise and a brittle sound that turned out to be RF related (we did not know until we opened it up that the default loading was 100k ohms, a lower setting cured all of the problems).
In the past, loading was needed to electrically tame the rising top end of cartridges as they approached their resonant frequency. Most modern cartridges have their peak so high up, there is no need for loading to tame the peak, as far as frequency response is concerned, but loading may help with some phono stages that are not equipped to handle the ultrasonic peak overloading the phono stage.
While I like it pretty wide open, some loading may be necessary, as others have mentioned, to prevent RF interference. I helped a friend with a Hovland preamp which suffered from noise and a brittle sound that turned out to be RF related (we did not know until we opened it up that the default loading was 100k ohms, a lower setting cured all of the problems).
In the past, loading was needed to electrically tame the rising top end of cartridges as they approached their resonant frequency. Most modern cartridges have their peak so high up, there is no need for loading to tame the peak, as far as frequency response is concerned, but loading may help with some phono stages that are not equipped to handle the ultrasonic peak overloading the phono stage.