Can I use the Mac Mini M2 with an Apple Cinema HD Display (23"- 2005 - DVI)?

My beloved 21.5" iMac 2009 has drawn its last breath, so I am considering other (not too expensive) avenues. I happen to have a 23" Cinema HD Display from late 2005 (DVI), which is in as new condition and works perfectly well (I have just double-checked). Would I be able to use it as a display for the latest Mac Mini M2?

In addition to the tech specs of the Mac Mini M2 provided on Apple's website, I have read as many threads as possible on this forum to try to understand how this might work (and the various problems that people reported) and what would be needed to this end, but most of the posts are about the Mac Mini M1, so I am still unsure. I have also read this useful article published in Macworld: https://www.macworld.com/article/233993/connect-old-apple-display-to-a-new-mac-to-give-it-new-life.html

Based on the information that I have found so far, it seems that I would need to get a USB-C to DVI adapter (this is, indeed, what Apple recommends here Connect a display to Mac mini – Apple Support (UK)) and that this would be the best solution, since a lot of people, it seems, ran into problems with a HDMI to DVI adapter, at least with the Mac Mini M1. Is this still the correct solution with Mac Mini 2 given that it uses Thunderbolt 4?

Others wrote that they managed to have their old Cinema Display work with Mac Mini M1 using a combination of an HDMI to DVI adapter and an Apple USB-C to Digital AV adapter.

If anyone has heard of or uses such a set-up, especially if it working successfully, I would be most grateful for any insight and advice regarding the kind of adapter/set-up that it most recommended. Many thanks in advance for your help.