Very very very expensive to do any transmission swaps for the V6. The only working manual V6 6th gen I've ever seen used a Legend's tranny.
You can get an 01 CL-S with low miles on it for $15K. The heated leather, navigation, sports suspension, and 6 speed is really worth it.