I've never been to Carowinds or Six Flags over Georgia, but I have been to Dollywood!
Dollywood is a fun little park, but you will probably get bored after you've done Thunderhead, Mystery Mine, Wild Eagle, Barnstormer, Blazing Fury, even Veggie Tales' Sideshow Spin, and the like. Also, if you're one of the people who want fun, long ride time coasters, you'll get dissappointed by Tennessee Tornado. Now, I know other enthusiasts are screaming "BLASPHEMY!" at my post, BUT I am typing from my sisters' perspectives! They said it was boring, not I!
My personal opinion? I loved the park. I went twice, one night then the whole day the next day. I went on all the "big rides", as did my sisters. I loved every aspect of the park, and took in every bit of scenery and architecture like there was no tomorrow. I appreciated the park for what it was, not for what it had. Dollywood is essentially a family park with some thrill rides thrown in. For me, I never got bored, but my sisters did. Quick.
So, if you're in to big bad roller coasters, Dollywood may not necessarily be the place for you. But if you're in to a more laid back, pretty atmosphere, then you might want to seriously consider Dollywood.
Also, at least to me, the park is kinda confusing, and you get quite the workout from the mountainous landscape.
Hope I could help!