theres nothing wrong with the 5th gen V6's... yeah its a little weaker than the j30a engine... but there are still performance options. The only problem I see with the 5th gen V6 is the heavy front end... but if you upgrade the springs, that usually takes care of the semi-sluggish handling.
Being the 5th gen V6 shared the same engine as the 1st gen legends, which can be found with a manual tranny, I dont see anything stopping anyone from putting a stick tranny on a 5th gen V6.