> Apollo 13 - I think few films come close to capturing how ingenious some people can be

I agree, I also like The Martian and The Shawshank Redemption, which both have similar premise of human ingenuity solving difficult problems.