It's hard to think about classic science fiction since Marvel Studios set a new standard and dominated the box office for the last 10 years, but Stan Lee is dead and Marvel sold out to Disney, so the recent attempts have been disappointing to me, although there is still an inertia that manages to keep the box office busy, even though the stories are more Disney than Marvel. Oddly both companies are/were top shelf at story telling, but what seems to me to be happening is that Disney can't do Marvel, and I doubt Marvel could do Disney very well. Maybe the Marvel Magic just naturally ran its course and ran out of creativity. But we seem to be back to the old normal with special effects more important than story telling, and catering to a smaller cross section of movie goers, maybe a much younger crowd.
But back on track. Remember the original Star Gate movie? Must have been 20 years ago now, and it did reach out to many sci fi fans. I thought it was just too unrealistic, and I was kind of bored with what happened when they got to where they were going. I was so uninterested that when the TV series came out and began it's remarkable 10 year run, that I didn't so much as surf by the show for just a second or two. It wasn't until after the series, actually, I think the third spin off was still current, when I discovered what a fantastic job the writers and staff did with the original premise.
The first couple years are not that important, and it takes time for the writers and staff to find their stride, but when they do, it just keeps getting better for the next 7 years, followed by the next spin off, Stargate Atlantis, which is maybe better than the original. The third spin off flopped in my opinion. I couldn't bother watching it after a couple of episodes, and hardly anyone even mentions it.
I love his smile; yep mesmerizing is a good description. Here's Joe's Wiki page listing all of his acting creds: 
