It's problematic comparing magic missile damage to that from a human fighter with a greatsword. Many have mentioned that there's no hit roll, no DR, no incorporeal chance. Also, often there's no real possibility of retaliation.
You're better off comparing it to a bow than a greatsword, and it...