I would like to know if it would be worth it to swap the transmission on my 2002 honda accord ex 3.0 v6 from an automatic to a manual?

If so what should i swap it to and what other modifications would i have to make?