Mine actualy blew up on me one night on my way home from work - when it was snowing. CEL came on, cleared it, drove fine. On my way home from work the next night - it finally went, wouldn't shift in any gear and had to pull off, let it cool, then go again. Took it to a shop the next day, long story short - they fixed it but they kinda ****ed me over and it cost $1800 for a rebuild, that was my birthday present to myself.
When it was acting up it would shift hard and I mean HARD and when it did shift it would'nt actually shift until like 4 grand almost. I could almost rev it to redline before it would shift sometimes, of course at that point it was completely gone. 2nd and 3rd gear bands, clutches, and a few other misc parts. Been driving fine ever since but there's no warranty on it and if it does go again....5spd swap.
Tranny's do not cost $4k for our cars unless you're getting a fully built one for racing or you buy it brand spanking new from the factory. If anything you might pay upwards of $1k for one from a junkyard and usually those come w/ a warranty from the junkyard. I myself wouldn't pay that much for one if I was just gonna replace it, $500-600 tops and then install it myself.