After nearly a decade of construction and a $1 billion bill, Hamburg’s dazzling gem is finally opening its doors