Uh, no. Unless your bearings are shot to hell or filled with sand, it will just feel like your headset is too tight.

All tightening the top cap does is pre-load your headset before clamping your stem on. It's easy to tell if it's too loose (headset will jiggle) or too tight (headset will bind).