Damning new analysis from the auditor-general has revealed more than half of the federal government grants for regional development were given to projects in major cities.