Not much to offer here. You must have your reasons for wanting an ancient Apple monitor with relatively low resolution. Getting it working is likely a matter of finding the right combination of adapters and cables. Where there's a will... there's a way.
The modern Mac generally "wants" a 5K monitor, for retina and because macOS basically needs an oddball resolution for perfect pixel scaling. Because it is oddball, there is not a lot of competition at 5K and that makes it more expensive than the nearby commodity resolution of 4K. Too bad that macOS doesn't easily scale to any resolution like Windows, but it is what it is.
If price is driving much of your thinking about trying to make that old Apple monitor work, I'd put the money towards a new 4K monitor. That will buy you much higher resolution and many people go that way with Mini. Even if the old monitor could be purchased for near nothing, I'd instead put the near nothing towards a modern monitor. There's no special advantage there to having an all Apple setup (in fact, it's probably a disadvantage).
If price is not a big driver,
Samsung just rolled out an Apple Studio Display clone for pretty close to the (IMO- too high) price of ASD. However, unlike Apple, Samsung MSRP tends to soon see many discounts in the retail chain. I wouldn't be a bit surprised to see that S9 monitor down at $1299 fairly quickly and probably valley-ing down around $999 at some point. That one would get you a 5K monitor much like Apples, minus Apples (too high) price.
Since you have long history with PCs and reference gaming, if you may still want or might add a PC to the mix in the next few years (gaming on Mac is limited), you might want to seek out a good monitor with 2+ inputs so it can double as BOTH a Mac and PC monitor (without having to switch cables). I went 40"
ultra wide 5K 2K from Dell with 4 such inputs and then hooked a Fat Mini (Studio) plus a Mac Mini-like PC to it.
It can even split screen, giving chunks of screen to each computer and has a pretty good built-in-hub so both computers can optionally share the same keyboard, mouse, speakers, etc. That price moves around a lot between about $18XX and about $21XX but some retailers may do better and refurbs have been purchased for about 25% off that. Since I do need both Mac and PC, this "one monitor for both" seems ideal to me. And I could never go back to a more square monitor typical of all Apple monitors. Once a person experiences UW screen RE, it's hard to return to near square.
Bottom Line: If you don't already own the ancient Apple monitor, I wouldn't be trying to make that work. Instead, I'd be seeking out a higher resolution monitor that better fits what is intended for Mac in 2023. Apple pushes 5K or more themselves but 4K is a popular compromise if budget is tight.