I've seen two productions, Davis Gaines at the Huntington in Boston in 1997 and Aaron Tveit at the Barrington in the Berkshires in 2017, plus numerous others on video.
The Hotel North in Pittsfield, MA is steps away from the Barrington. I stayed there when I went to see Company with Aaron Tveit at the Barrington in 2017.
The people in that stadium had just stood in line for hours in 90 degree heat, having to show proof of vaccination to enter. Talk about a tough audience. The performers did very well, indeed. As for Aaron not being sexy and/or lacking charisma. There is a vast majority who would find that ludicrous.
The show was far better in previews in Seattle than what opened on Broadway. Aaron's role was reduced, Norbert's role was enhanced and some good songs were eliminated.
As an analogy, after Reagan died, there was a move to put his face on the dime until Nancy Reagan put a stop to it. She said that Reagan had been a fan of FDR and he would have disapproved of the effort to remove FDR's face for his. Also, there were multiple namings of streets, buildings, parks, etc. after JFK died, some of which were rescinded in time. Remember Cape Kennedy?
The production of 9 to 5 that premiered in Los Angeles was infinitely better than what opened on Broadway. Same can be said for Catch Me If You Can. The Seattle previews production was so much better than the revised Broadway production.