It's not so much the CGI I don't like as the obvious nature of it, and how easy it is to spot. The best effects are completely invisible to you, instead of a filmmaker going 'look, look, look at all these wonderful effects in my film!'
There's a story recounted from Alfred Hitchcock about filming Birds. After it was released they had some complaints from people writing to say that one of the birds used in the film was so obviously a fake and why couldn't they have trained a real bird/used a better prop etc.
Turns out there were hundreds of fake birds, and in fact most if not all of the birds seen up close were fake. Which meant that out of hundreds of fakes, the SFX only failed once.
Contrast with today, Avatar might be breathtaking and all but it doesn't feel real. You know what you're watching is entirely computer generated, and that's the entire point of it. Avatar is an excuse for a Computer Animation department to show off, nothing more, and no matter how well done the scenery, I never once believed this place existed.
As for Star Wars I actually think the prequel trilogy wasn't too bad on the effects front, largely because they basically did everything in CG, and some of the backgrounds of Coruscant look so real you'd believe there was a city there, or Kashyyk, where the trees and beaches and water (all CG) look good enough to make you believe that they went somewhere and filmed it.
Look also at Lord of the Rings, I have a book detailing the CG and special effects used in LotR, and some of them are absolutely unnoticeable even with this book to hand telling you it's fake.
That's what I want, I don't care if it's CG, or a model, or anything, I just want it to feel and look real, like I could really set foot there and walk around.