In general, tight is right. The cliche really does apply: you can't win the game in the opening level, but you can definitely lose it. Even be prepared to do things like fold in the small blind when it's limped around and you're holding garbage.
The important thing is to be able to change gears and get more aggressive as the blinds get higher and the stacks get shorter.