I actually liked Insurrection when I finally saw it. Particularly after it's bad reputation. For me, the worst is "Generations". The magical storm thing just felt daft to me. Nemesis had its issues, but it has the best spaceship battles out of any of the films.

How do you know they didn't find a god in Star Trek 5? They never say it was the devil.