Hey, I like the later seasons, too, so you're not alone.
I think much of the hype was people reacting to the technology and the visuals, but then presenting it as if that was the whole movie. So, someone says "OMG!! THAT MOVIE WAS AWESOME!!" but they aren't speaking the same language as you (or I). To me, an "awesome" movie will have good visuals, sure, but also a really compelling, interesting story. If it lacks that, then it's not a good movie, right? Well, not so for most folks, I've come to learn. People like big, shiny, and don't really give a fig for the rest. Unless there's something so blatant about the story/humor/script/characters for them to actively hate, they'll be satisfied by visual spectacle alone.
Fine and dandy, but you've got to keep that in mind when folks give you their opinions. So, "OMG it was an AWESOME movie" may really just translate into "OMG it had AWESOME visuals!!" With that information, from what I've heard at least, Avatar could be accurately described at least in a 3D theater. But I honestly don't know.
And that is a wholly separate issue -- you might still not dig the visuals. These days, I find most CGI to be really underwhelming. It never looks real to me because it doesn't move realistically and it isn't lit realistically. It doesn't look like it occupies space. Maybe Avatar in 3D is better, but I rather doubt I'm gonna watch it and be blown away the way I was by Jurassic Park, ya know?