In the Equestria Girls verse, yeah Twilight is the Carrie in the Human world while the Sue Snell role would be Sunset Shimmer.

In the pony world, it would be Fluttershy as Carrie while the Sue role would have to be Twilight Sparkle.