All bearing assemblies should be adjusted as smooth as possible with no play, it should be no tighter than whats required to remove the play from the headset, (you can test for play by holding your front brake and rocking your bike back and forth)