M2 or M1 MacBook Pro & legacy 23" Apple Cinema Display - possible?

https://everymac.com/monitors/apple/studio_cinema/specs/apple_cinema_display_23.html

if that is your display, according to Everymac.com it has a Single-Link DVI input, and 1920 by 1200 resolution. DVI displays up to but not exceeding 1920 wide can use Single-link DVI.

That is instantly adaptable from HDMI with a cheap "all wires" adapter, -OR-

converted from USB-C with a slightly more complex adapter or adapter/cable.

You can use one like this from your built-in HDMI port:

Monoprice High Speed HDMI Cable to DVI Adapter Cable 6ft - with Ferrite Cores Black - $3.14

or one like this than keeps your USB-C available for charging, ONLY and provides a USB-A for data

Monoprice Select Series USB-C to DVI, USB-C, USB Type-A Multiport Adapter - $19.99

Apple only sells official Apple adapters for Apple brand compatible devices that are currently on sale. All others are left as an exercise for the User.

The moment either device is not currently for sale, the official Apple adapter (if there ever was one) is GONE.

Apple's 'company line' is "we will provide products where we have something special to add".

The unspoken part of that is "we are NOT doing 'regular' commodity adapters"