Yes I agree that if it is folded pre-flop to the CO, tight or loose, fat or skinny, most players will raise with moderate hands. In this situation, yes, I would think that the players left to act are more likely to make a move on you because they know you are tight and could easily back you off of that so-so hand you just raised with. But say this is not the case. What if you have three or four limpers and you raise from the CO? Then I think people are much less likely to make a move because not only are there too many others in the pot, namely tricky early position limpers, but also teddy tightpants who just raised a multi-handed pot.
...but a tight player is probably more likely to back down to a reraise preflop than a loose player, and the other players know this...
I don't agree with this logic. A very tight player, is tight, but not necessarily passive. It sounds like you are describing a tight passive player. So if someone is tight, they are going to wait until they have a premium holding. The pre-flop betting is around to them, they call or raise. Someone re-raises them. If they are at all a thinking player, they should know how their play compares to the table, namely, that they are tight. Subsequently, they should also know that their holding is not a severe underdog to any other possible starting hand, because, hey, they are tight. So they will call/raise the majority of the time. Post-flop is a different story. In order for my logic to be correct, however, two things must happen. The hero (very tight player) must be a thinking player and know what it means to be tight, and also the villain (player looking to take advantage of the hero) must be a thinking player and know how tight players act. Does this make sense? I feel like I'm blowing smoke up your arse now.