I actually watched the original Alien movie on Saturday. It still looks great not only due to it's story/direction, but also because the effects still look impressive as real sets were built and used. The actors also behave more realistically since they are dealing with actual props rather then performing in front of a blue screen.
As said before, if CGI is used then it needs to be used in moderation - otherwise the movie just becomes a phoney looking mess.