This probably won't be much help (I haven't been to Carowinds sicne I moved to Texas ... I really miss that place!) But I'll give it a shot ...
I've never been on a Sunday, but I can only guess the crowds would be a little lighter then. (However, if you're going the weekend of the 22nd/23rd, know that the park closes at
6:00 on that Sunday! So I would go on Saturday -- the 22nd -- if you come that weekend.) Get there a little before the park opens (it opens at 10:00, but they've always opened the gates -- and the shops -- before then.)
If you're planning on riding the Super-Saturator, ride it early in the day, because the lines get longer the later in the day you go. You don't really like water rides, from what I remember, so Rip Roarin' Rapids and WhiteWater Falls wouldn't be for you. The Powder Keg Flume (Log Ride) is loads of fun and you don't get wet at all, if you're into that sort of thing. Make sure you ride Top Gun (B&M Invert), Thunder Road (racing PTC woodie -- backwards is my favorite!), and the Hurler (wooden triple out and back with some nice air-time.) Vortex is nice (a 2-inversion B&M stand-up) but from what I hear it's nothing special once you've ridden some "bigger" B&M stand-ups. I still like it, though. The Drop-Zone (Intamin free-fall tower) is OK, but not worth a long wait. Go only if the lines are short.
I know very little about the new section they've opened up this season, except there's a new Mack Wild Mouse there. The lines for that will probably be pretty long. I hear they've torn out some of my favorite restaurants, so I don't have a lot of advice about where to eat. (If the burger joint near the Gauntlet -- "The Village Tavern", I think -- is still open, you might want to try there. The prices were reasonable and the food was pretty good -- last time I went, at least ...)
There's a really nice Comfort Inn directly across the street from the park. We've never stayed there (we lived close enough to not need a hotel when we went) but all of my friends who stayed there said it was rather inexpensive and was very nice. Here's a link to some info. on it:
http://www2.choicehotels.com/ires/en...l=SC416&int=no
Charlotte roads are always under construction, but luckily you won't have to go that far north. You'll exit on the S.C. side of I-77, if I remember correctly. "Carowinds Boulevard". At any rate, the roads should be fine.
Well, I think that's about all the advice I have for now. I hope you have a good time there! (I'm jealous! I want to go there again!!

) I'll post more if I can think of anything else. Or you can P.M. me if you'd like.
Hope this helps!!