A new 'super hospital' will open its doors to patients and staff officially tomorrow after being fraught with difficulties during its building.