FYI... this is only going to confuse matters...
First Understanding the basic problem:
From my understanding, basically the DVI specification can't carry more than 1920 wide or like 1200 tall at more that 30Hz (refresh rate.) Please do not quote me on the numbers above, but understand DVI can only deliver a certain amount of Data based on the general function of = height * width * refresh rate.
The older 30" Apple HD monitors can deliver a lot more data than what a single DVI can deliver so Apple used a technology called "Dual DVI," and even more confusing is that there are a couple of flavors of "Dual DVI" and Apple's version was only used by them. Basically Dual DVI delivers the signal in 2 parts and then re-syncs at the monitor.). This unique Apple Dual DVI flavor makes buying the correct dual DVI adapter tricky on Amazon. Good news is for Apple HD monitors under 30" (27" and 24"), they don't use that much data, so don't need the dual DVI.... I think. So for a 23", I recommend skipping the extra headache and get the single DVI solution.
What to watch for when buying dual DVI.
The Dual version you listed from Amazon.... there are two flavors of that one and honestly I am not clear exactly which one works because the tiles say one thing but the reviews and fine details say otherwise.
This one in the title says it doesn't work with the 30" but review comments say it does.
https://www.amazon.com/dp/B07QKM856C?psc=1&ref=ppx_pop_dt_b_product_details
and this one:
https://www.amazon.com/dp/B08B7FSVTL?psc=1&ref=ppx_yo2_dt_b_product_details
This is why I just spend the extra dollars and look on e-bay for the Apple Branded dual DVI. I had an off brand years ago and it worked... most of the time. Just tired of 'most of the time'.
NOTE:
Also Grant makes a fine point, with the Apple branded Dual DVI part, you need to plug the USB pigtail into USB power. With the amazon one, you do not.
Back to a simpler solution,
Get the cheaper single DVI solution from Amazon. Stack it on top of the USB-C to display port adapter and should work just fine. But buy them all (The ones above) and return the ones you don't use.