Western firms profited as kingdom launched ‘giga-projects’ but market is slowing as Riyadh reins in spending