Plans for 'super-hospital' scrapped