In theory I believe the answer should be that you will never be DQ’d under a CE race setup in the future. The link at the bottom provides recent information from Zwift but relevant wording shown below.
“By default, events in ZwiftPower will no longer Upgrade or DQ riders based on their category or W/Kg limits. This is because we plan to use Category Enforcement in the majority of events going forward”
.
I notice you don’t race much but see that you unfortunately received a UPG on Rapha Rising 2023 and 2022. From what I can see in the thread linked below Rapha Rising was not ideally configured and there are possibly plans to improve the ride/race configuration next year.
.