I agree with you that it is very important to know when to use Pearson, Spearman or Chi-square tests. You have explained well how each test works with different types of data and why it is important to choose the right one. Using the wrong test can indeed lead to wrong results, so checking the data type and distribution first is key. Your examples make the differences easier to understand.