Not sure what you are after (do you just want a list of some common NHST tests?), but Book Testing Statistical Hypotheses
is often given for understanding what are hypothesis tests. It can be downloaded from https://link.springer.com/content/pdf/10.1007/978-3-030-70578-7.pdf?pdf=button%20sticky .. This is aimed at statisticians. There is simpler coverage in most introductory texts. I would avoid "lists of tests" books.
For an intuitive guide, you could check out Frost's (2020) book.
Frost, J. (2020). Hypothesis testing: An intuitive guide for making data driven decisions. Statistics by Jim Publishing. https://statisticsbyjim.com/hypothesis-testing/hypothesis-testing-intuitive-guide/
For a book that focuses on application and interpretation, Fay and Brittain's (2022) book can come in handy.
Fay, M. P., & Brittain, E. H. (2022). Statistical hypothesis testing in context: Reproducibility, inference, and science. Cambridge University Press. https://doi.org/10.1017/9781108528825