this is by no means a well educated guess, but just a hypothosis... maybe when the chain is really tight it's putting a little pressure on the bearings in the BB and so it's not as free to spin on a whim?