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