Tidal stabilization

Once upon a time, there was a discussion here about colonies that have to
point towards the sun (e.g., O'Neil Cylinders) versus colonies with
rotational axis perpendicular to the orbital plane (e.g., a torus lying over
its orbital plane). The group favoring the "non-pointer" colonies argued
that a colony with rotational axis parallel to the translational axis would
be in a stable orientation and would naturally remain like that forever,
while a "pointer-colony" would need some mechanism that would permanently
correct its orientation towards the sun. (E.g. O'Neil Cylinders come in
counter-rotating pairs in order to cancel the gyroscopic effect.)

Recently, I remembered that many artificial satellites that need to point
towards Earth use tidal stabilization, the tendency of an object in orbit to
point its longer dimension towards the object being orbited, in order to
keep their orientation in a stable, natural way. Tidal stabilization also
occurs naturally in many natural bodies of the Solar System, like
potato-shaped moons that have their major semi-axis pointing towards their
planets (e.g., Almatea around Jupiter). And then I wondered if tidal
stabilization can be used to keep a colony pointing towards the sun in a
stable way. I imagine for instance a cylindrical colony with a long tether
holding a conterweight pointing towards the sun. But I have no idea of how
long/heavy would that tether/counterweight system have to be in order to
provide a tidal force stronger than the one generated by the gyroscopic
effect. Could anyone help with that calculation for some hypothetical case,
in order just to give some hint of the viability of this idea?

Lucio Coelho