S shaped down tube (MTB)
The S shape allows for:


stronger head tube and bottom bracket welds without the need for gussetting. You'll find this on more trail focused bikes (such as AM, FR and DH).
wheel clearance for long travel forks
wheel clearance for the front wheel (ie. 29er's)
Still allows for room for a water bottle within the front triangle