For me, no. My favorite movie is the Matrix Reloaded but I am well aware it's not the greatest movie. I think it has a lot of really cool things with its writing and direction but it's far from the greatest.
Honestly, most movies I'd tag as "greatest" would be for cinematic reasons and likely won't be my favorite just because it's too artsy and requires brain cells to appreciate.
<script type="text/javascript">alert("remember when scripting attacks worked?");</script>