904 to A230 worth the effort?

No, not from a 3 speed auto to a 3 speed manual. If you really want to enjoy a manual transmission go with 4 gears. Yes the OD are getting pricey, but you will benefit over the auto with an increase in fuel economy. From my point of view you are doing the same thing as swapping to a 4 speed but without the 4 speed.