The troubled new Manchester arena finally opens its doors to the public at the fourth attempt.