I think the chemistry is due to Columbo being sort of unworldly and sophisticated, and upon meeting someone of a different background as himself, he is fascinated and wants to be respectful and courtesy and not make waves. The same with being in different suroundings, such as on the cruise ship. They all show his humbleness, which endears him to us all.