[FEA]: Migrate fail test utilities to top-level; reuse between projects

### Is this a duplicate?

- [x] I confirmed there appear to be no [duplicate issues](https://github.com/NVIDIA/cccl/issues) for this request and that I agree to the [Code of Conduct](CODE_OF_CONDUCT.md)

### Area

General CCCL

### Is your feature request related to a problem? Please describe.

CUB tests are able to have fail tests:

https://github.com/NVIDIA/cccl/blob/a1e1337b6a017bca4373c04e88ca11310fa7bf6d/cub/test/CMakeLists.txt#L271-L298

### Describe the solution you'd like

We should consider hoisting this functionality to the CCCL level, and use it for compilation errors testing in cudax and Thrust.

### Describe alternatives you've considered

_No response_

### Additional context

_No response_