the V6 trannys are extremely problematic. the 00's and 01's have their tranny warrantees extended to 100,000 miles, but the other years are SOL.
modding a V6 to a 5 or 6 speed is extremely expensive ... for 20K, you're better off getting a similar year TL-S or CL-S