A new 'super hospital' finally opens its doors to patients and staff this weekend after being fraught with difficulties during its building.