Automatics are a bit more than manual, about 1000 to 2000 US. Replacement is reasonable if you find the right mechanic. Do not go to the dealer, they will rip you off.
Automatic is definitely not for pussies. As a guy who knows how to drive both manual and auto, I would choose Auto as a everyday driver. If I'm storming down a B Road then I would want a Manual, but if im sitting in traffic, I dont want to be rowing through 5 gears just to move.