1. 3dsmax is but one 3D/animation program, most are multi-platform (see Maya, Cinema 4d, Modo etc...). No, it's not the "industry standard".
2. PLM software like Inventor and SolidWorks are underrepresented on the Mac. Software like Fusion 360 and OnShape[0] are beginning to make up for this
3. AutCAD is available for macOS. Has been of about 5 years. Autodesk in fact produce plenty of software for the Mac... [1]
4. No, but there is Xcode. And IntelliJ.
5. No Excel? Microsoft appear to disagree. [2]
Based on your comment, you have no clue what you are talking about, and I'm so bored of seeing this nonsense every time this comes up. Please, stop.
[0] https://www.onshape.com/ [1] http://www.autodesk.com/solutions/mac-compatible-software [2] https://products.office.com/en-gb/excel
In my considerable experience using Office on Mac in tandem with Office on Windows, the Mac experience is severely, severely degraded in comparison.
Extreme slowdowns in large documents, odd crashes, and difficulties handling macros are pretty much the defining experience for Office 365 on Mac for me.
The Mac "equivalents" where they exist are far inferior.
How does the Mac have better available software these days?