MS project isn't for most people in office environments. After all how many of us have projects where we really know what will be required six months down the line?
However we commissioned a major (£1.5M) renovation of a community building in a previous charity, and the project plan was designed in MS Project by our major contractor & architects.
That was only a small build in the scheme of things, but the level of complexity blew my mind - 1 major contractor with a total of 79 sub-contractors. Every sub-contractor needed a small window of time, sometimes 9 months down the line, to do their work and they would only be able to do it every single previous step was complete. Genuine critical pathway stuff. (You cant paint a wall until its built, after all)
So in those situations MS Project was great. But for many cases, its overkill.