A man is in hospital in a critical condition following a horror multi-vehicle crash on a major city motorway.