monarch: I'm going to tell you the realities - if you have NEVER driven in Ireland before you do NEED to secure an automatic not only for yourself but OTHERS on the road. You will have enough to do driving an automatic in Ireland - looking where your going- for road signs (and scenery) staying on the correct side of the road, dealing with on coming vehicles on smaller roads - turning around (this will happen loads) as well with vehicles overtaking you. When it comes to the roundabouts - which are many in Ireland there is ETIQUETTE on driving the roundabouts - ie: which lane to be in on the roundabout determined by which "exit" you need to take - while trying to deal with other cars & especially Lorries AND ... Yup ... Road SIGNS. Now having to deal with ALL that and any other sudden situation that may come up and a clutch on the left side can be too much - as you will tend to look down at the stick to shift and it only takes a second - BAM!
I have SEEN mva's in Ireland involving American tourists and have read stories of others in the papers while visiting there. I have family in Galway & Clare and am about to take my 9th trip soon to take my Mam home for a visit (she was raised in both counties). I'm not trying to scare you - driving in Ireland can be fun with the right vehicle.
Another thing to keep in mind is depending on your trip - if you plan on keeping your luggage in the vehicle as you sightsee during the day between stops you will need to make sure that no luggage or bags (purchases) can be seen in the car, therefore, you will need a vehicle with a small trunk or one that if a hatchback has a concealer - it doesn't matter if your in the city or out in the country - lets say at the Dolman in Clare - you have that element. As this little old Irish gent told me at the Dolman - "They will steal the eye out of your head".
Now you've spent all this money to travel to Ireland don't go too cheap with the rental. Be safe. You want to enjoy your trip.
Check out this site which does have vehicles that have inclusive (includes the CDW). Rentalcars.com
There have VERY reasonable INCLUSIVE automatics on the economy chart.
Bottom line - if you have to pay a little bit more for safety - pay it. Like I said at the beginning - realities
Be safe and have fun.