I don't use Stow, but in learning what it was I did see that they did a release two days ago that sounds like it may have fixed your issue:
https://lists.gnu.org/archive/html/info-stow/2024-04/msg0000...
https://lists.gnu.org/archive/html/info-stow/2024-04/msg0000...
But maybe stow wasn't made for this, maybe someone should reinvent stow with dotfiels in mind. And no chezmoi doesn't count.