Scott’s Senate colleagues adore him, and voters’ views of him were favorable, but he never translated that into real support.