Two great films of Connery that receive little promotion are
Zardoz - a late 60's way-out-there science fiction about a dystopian future. fun fantasy with moral ideas.
Outland - set on a mining colony on Mars where Connery plays a security man chasing down a drug distribution network. hard reality.