I think a lot of us grew up hearing that. I have though become fearless in changing my tension. It can be different depending on what thread and fabric and needle you are using. I try to always do a sample, and then fine tune the tension.
Top tension is the less "scary" to change. I bought a separate bobbin case that I use when I want to change my bobbin tension...usually if using a heavier thread.