Does anybody know if the 2004 Accord V6 Motor will mount to any S2k Tranny and if the V6 spins the right way.

No. The bellhousing won't match up.

i am not putting the motor in a s2k it is going into a 1940 chevy i got the motor for free and i do not want to spend the money to buy and build a small block i can get a s2k tranny for $200 no problems.

Probably not. You'd need an adapter plate, you'd need a clutch package that will match both, etc. Just use something else.