Call me a fanboy if you must, but the people at Coding the Architecture know their stuff. The slides Simon Brown put together on Why Software Projects Fail are a very good, very specific description of what a good software architect can bring to the a project