Would be a shame having to do that but it's your call.
There are active dual link DP to DVI cables if you want to search into it.
Glenwing has a couple of guides regarding all sorts of things about displays and cables.
Glenwings Guide to Display Cables / Adapters (v2) This Revision: 2.5.0 (2020-01-16) This is a guide intended to assist with the selection of cables and adapters. It covers the different types of DisplayPort, HDMI, DVI, VGA, and USB-C cables, as well as every possible combination of adapters betwe...
linustechtips.com
Table of Contents: 0. Acer GN246HL and BenQ XL2411Z-specific instructions 1. Terminology 2. Summary: How to Connect to a 120+ Hz Monitor 2.1. DisplayPort 2.2. DVI 2.3. HDMI 2.4. "Which one should I use?" 3. DisplayPort 3.1. Full-Size DP vs. Mini DP Connectors 3.2. DP Versions and...
forums.tomshardware.com
Have you thought about taking your monitor and cable to a pc store and get them to test it? Wouldn't take more than a few minutes of their time surely.
So it's looking like either monitor is flaking out, are you sure DVI works?. Or have had a bad run of luck on DP cable.