Them showing up in the middle of the Eugenics Wars would have been a lot more interesting, yeah. But I would have preferred that they just returned to the Earth they knew and received a hero's welcome. The whole "Okay, the Xindi have been defeated...but now there's this!" twist at the end is entirely unnecessary.
That was always my take on it, but seeing the Eugenics wars, and possibly a younger Khan would be cool too. On my last rewatch, I just skipped Storm Front entirely and started season 4 with Home.