Of the games I have played enough to rate against each other fairly:
MK:Wii >>> MK:DD >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> MK64
I have played a little of both SMK and MK:DS.
DS I would expect to fit in about 5 or 6 arrows below DD... though with my limited time I haven't had to experience online snakers.
SMK I think would fit halfway between DD and 64... mainly because it is now dated rather than substandard.
I haven't played SS or 7 at all, so can't comment.
I'm more of a racer than a fighter, so I don't have a huge interest in battle mode. But I view MK:Wii and MK64 battle modes to be the best, MK64 being the best executed, but Wii is saved by having online battle mode and more players and the coin thing (MK:Wii would have been leagues ahead if up to 4 teams were allowed instead of just 2)
SMK battle mode was also good, most of the 40-50 minutes I spent on the game were spent in battle mode.
Double Dash battle mode was atrocious.