It's kinda ironic that they had fantastic on set chemistry that rarely translated to the screen.
I feel like they had decent chemistry. They were written the way they are, for good or ill. Hardly something that struggled because of the actors, imho
Politics aside, I find it really hard to read Spiner based on his interviews and convention appearances. I tend to think that the "arrogance" that he portrays is kind of an act, a form of him trying to be funny.
It strikes me that way too. If you ever watch his web series. It's clear he has a self-deprecating sense of humor