Tight !
I run mine plenty tight so they don't move when I take my feet off for no foot can's & etc; but I can still pedal and turn the cranks with my hands when needed.
IMO If you can throw a full crank spin with your hands it isn't tight enough. I can throw mine about half a revolution.
All personal preference though.