i just made a post about the auto to manual here-
https://hondaswap.com/forums/index.php?...t=0&#entry63516
its very do-able. Calesta's sedan was an automatic that was converted. depending on how good you can score parts for it, it can be done cheaply. having a shop/dealer both find you the parts and do the conversion will be a lot of money. keep that in mind.
if you are in the texas DFW area-- give intercrew atuosalon a call. they are the shop that did Mike's conversion.
I'm sure there are other's on the board as well who have had this done.
the REAL question is, what is the car worth to YOU, regardless if it was free or not. Is it sell-able? clean title? things of the sort