Depending on how far you're willing to drive..
1991 Geo Metro, says 4 speed manual? Thought they were 5 speeds even back then. $1200 in Reno.
https://www.facebook.com/marketplace...4807567886896/
2001 Suzuki Swift in North Highlands, CA (a bit of a drive from CC) with new transmission and clutch for $1800.
https://www.facebook.com/marketplace...2215182311450/
Could use the tranny and have a spare parts car. Not sure about compatibility on the first one though. Cheaper than $3000 for a rebuilt trans though.
Found a couple Insights within a 3 hour drive from CC. Both were ~$5000 located in CA. The others were either automatics or parts cars.