honestly, most of the new chevys come with Dex 6 in the low power manual trans.
Cobalt SS, camaro, corvette all have standard 75-90 gear oil. But non-SS cars with Standard Trans usually have Dex 6 or Manual trans/Transfer case fluid (fairly similar).
Dex 6 is full sythetic, super high quality and actually fairly expensive. When it was first introduced, it was like $20+ per qt. Anyways, Ill look up what it takes tomorrow, but you'll have a hard time finding a better fluid. DEXRON (2,3 and 6 are interchangable, 6 is full syn) is used by A LOT of manufacturers. Toyota uses it in there power steering systems, Nissan/Infinity use it in their trans and transfer cases (Skyline/G35), etc. It might not be worth it to change, and could affect warrenty if the fluid is not to required spec.