Hmm... interesting. But then, being a good general does not necessarily entail one to being a good leader. Nikephoros Ouranes could be a more likely choice if you would like the Macedonian dynasty to continue - Zoe would have been around 20-21 around the time of his victories, and as such would have had just about every chance of conceiving. With Nikephoros Votaneiates/Xiphias (who, I presume, was probably related to Emperor Nikephoros III, who was eventually overthrown by Alexios I Komnenos), Zoe is in her mid-30s. Not necessarily a deal-breaker, but there is less time for any potential children from this marriage to inherit. Especially since Zoe lived for quite a long time OTL, and as such, if she dies childless, her eventual husband may create the same problem of succession as in OTL.
Of course, things get more interesting if Zoe is used only as a path to the throne, in which case whether or not she is the mother of the eventual heir does not matter. In this case, she only needs to last as long as Basil II and Constantine VIII, after which her eventual fate does not matter much. Well, does not matter much but with a few exceptions.
First, there is her sister Theodora, who represents another legitimate link to the Macedonian dynasty. While Theodora was, AFAIK, more interested in religion than in marriage, it is not impossible to postulate that she is also, in turn, married off to someone, or is used to mount a coup in her name. So any potential successor to Basil and Constantine that inherits through a marriage to one sister would always have to be mindful of the other sister as a potential rallying point for any enemies of his regime. And that sister may not be easily removed, as illustrated by the below point.
Second, in OTL, both Zoe and Theodora, though despising each other, were given an additional air of legitimacy by the population. When Michael VI Kalaphates tried to remove Zoe altogether and rule in his own stead, he was overthrown quite violently within a very short time, leading to the joint installation of Zoe and Theodora as the rulers of the Empire. If Basil and Constantine's successor tries to remove one or both sisters, he is risking a counter-coup that he may be lucky to escape with only a blinding or the like. He may be able to get away with putting one of the sisters in the convent, but even then, he leaves a potential threat in his back that he can do nothing about without risking a coup.
So, the situation would be, for such a successor to maintain his throne and perhaps found a dynasty, would be for him to:
1) Marry either Zoe or Theodora before they are not likely to give birth to any heirs
or,
2) Marry one of the sisters, while something happens to the other that can be nothing but natural or unrelated causes - so that the new Emperor is not blamed in any shape or form for it; again, something happens to the new Emperor's wife after the deaths of both Basil and Constantine, but again, without the new Emperor appearing guilty, true or not
or,
3) Be adopted by either Basil or Constantine (the latter would be harder, since I cannot imagine Constantine adopting a potential heir without forcing this heir to marry one of his daughters instead of adopting him - see the fate of Romanus III Argyros), AND be declared the undisputed ruler of the Empire
These are listed in the order of favorability for the survival of such a would-be Emperor in the long term. Any of these could be made to work, but may result in very different butterflies down the line.