I think this is very dependent on number, types and quality of speakers, etc.
I'm running 7 speakers at the moment, the usual 5.1, plus two front presence speakers.
For sports like football, the Sports setting does work well for me.
For movies, in order of preference: SciFi, Spectacle, Adventure. Some movie DSP's are better than others for dialogue clarity, depending on the source.
For music: 7 Channel Stereo really makes it pop. Music Video also works, but doesn't...