Update the stream testing utility to completely disallow calling certain non-stream-ordered functions

This makes me wonder whether we should update the [stream testing utility](https://github.com/rapidsai/cudf/blob/main/cpp/tests/utilities/identify_stream_usage.cpp) to completely disallow calling certain non-stream-ordered functions if they have corresponding stream testing variants. Would we ever want to use cudaMemcpy instead of cudaMemcpyAsync in our code base anymore, for instance? We can always pass the default stream as a parameter to get back to the legacy behavior.

_Originally posted by @vyasr in https://github.com/rapidsai/cudf/issues/20374#issuecomment-3457532787_