Sean Connery is undoubtedly best known for his iconic role as James Bond, as well as his performances in films like The Untouchables and The Rock. However, he also made his mark in the realm of science fiction films. 

Connery's appearances in films like Zardoz, Outland, and Highlander allowed him to explore a range of complex and thought-provoking themes that are often associated with the sci-fi genre, such as dystopian societies, the nature of reality, and the dangers of unchecked power.

In these films, Connery often played characters who were at odds with the dominant power structures of their worlds, using his charisma and commanding presence to bring a sense of gravitas to these often fantastical tales. While he may be best remembered as the suave and sophisticated James Bond, Sean Connery's contributions to the world of science fiction film cannot be overlooked.

Here's a list of some of the films that Sean Connery has acted in that feature science fiction elements and themes:

1. Zardoz (1974) - In this dystopian science fiction film, Sean Connery plays Zed, a brutal enforcer for a community of immortal humans who have isolated themselves from the rest of humanity. The film explores themes of sexuality, immortality, and the dangers of seeking utopia.

2. Outland (1981) - Outland is a science fiction thriller set on a mining colony on one of Jupiter's moons. Sean Connery plays Marshal William T. O'Niel, a law enforcement officer investigating a series of mysterious deaths. The film features themes of corporate greed, worker exploitation, and the dangers of unchecked power.

3. Highlander (1986) - Although it is primarily a fantasy film, Highlander also includes science fiction elements, including time travel and immortality. Sean Connery plays Juan Sánchez Villa-Lobos Ramírez, a mentor to the film's protagonist, who teaches him how to survive as an immortal.

4. The Time Bandits (1981) - This comedy-adventure film features Sean Connery in a small but memorable role as King Agamemnon, a historical figure who is accidentally transported through time by a group of mischievous time-traveling dwarfs. The film explores themes of free will, the nature of reality, and the dangers of unchecked power.

5. The League of Extraordinary Gentlemen (2003) - This action-adventure film is based on a comic book series of the same name and features Sean Connery as Allan Quatermain, a retired adventurer recruited to lead a team of legendary literary heroes on a mission to save the world. The film features themes of imperialism, technological advancement, and the dangers of hubris.

In all of these films, Sean Connery plays characters who are often at odds with the dominant power structures of their worlds, whether they are brutal enforcers in a dystopian society or retired adventurers brought back into action to save the world. The science fiction elements in these films allow for exploration of themes related to power, control, and the nature of humanity itself.