The Higgs vacuum uplifted: revisiting the electroweak phase transition with a second Higgs doublet