From what I know, most freshmen get placed in Brody (largest dorm, dirty, community bathrooms, but also probably with the biggest freshmen party scene). However its such a big school so you'd find parties anywhere (you prolly just want to avoid alcohol-free quiet halls/dorms).
As for locations, there are several zones
University Housing | Michigan State University | Campus Life | Residence Halls | Campus Zones
From what I've heard, west circle dorms have the best food. Akers is pretty far away from the middle of campus. South dorms are also very popular (case, holden, wilson, wonders), especially for athletes. Mason-abbot, snyder-phillips and shaw are in the center of campus and also widely requested. Some dorms with fitness centers include Case and abbot.