HSV scored twice in the closing stages to secure a come-from-behind victory and pile more misery on 10-man Hoffenheim.