Yeah, Maxwell and Newhouse are pretty prestigious, but the business school, engineering school, and performing arts school are meh, and you're way better off majoring in a traditional "education path" subject (history, English, language, math) at a SUNY or Le Moyne than you are with the price tag that comes with SU - the programs are nothing special and there are no big names in academia to bolster anything. The music school is also far inferior to Potsdam, Fredonia, and Ithaca, let alone Eastman at U of R.
The University brings flash by having "professors-in-practice" at places like Newhouse, but that's not really reflective of academic leadership - that's career training.
Academically, Syracuse banks on its reputation from a few schools and really leans into big name alums to prove it. A lot of its recent prestige comes from sports, especially basketball.