[CI] Use single CI variable for enabling all Valgrind tests
Description
This MR makes the CI more consistent by having a single way to enable/disable the valgrind tests.
Checklist
-
Documentation reflects the changes made. -
Merge Request title is clear, concise, and suitable as a changelog entry. See our contributing docs
References
Closes #1294 (closed)