Tightening until you cannot spin the pushrod is too tight.
You would make sure the lifter is not on the cam lobe (non lifting section) tighten the rocker arm nut until there is no up & down play on the pushrod, then proceed to tighten an additional 1/4-1/2 turn, usually 1/4 turn is good.
MBHD