it is a bit sad CUDA modules are dying slowly.
From my experience, CUDA is not really a must have with OpenCV. It can brings things but i never saw something really significant.
It will be more interesting to replace Numpy with Cupy in OpenCV. Cupy is really great and bring some real improvements (i mean speed improvements).