TBrack,
I've also took the C4C deal couple weeks ago for my 97 Q45t.
My car failed smog check with 200k miles...didn't want to bother with the repair so go the Cube (base model).If you are planning to do the same, better act quick. The dealerships are selling quick a bit of cars thru this program.
You've mentioned your tranny is dead. Is it completely dead? I've read somewhere and says the car has to be driveable condition for the C4C program.
Good luck and hope to see you in a new cube soon!!!
007