WOW It's been a long time since I've seen so much misinformation in a single thread! I'm from the US, like the OP, and I have a cottage in Ireland. I've been spending a couple of months a year in Ireland for the last decade, and rent a car every trip, usually for 3 weeks at a time.
1) You can decline CDW with some rental car companies.
2) Many will not accept alternative coverage, like insurance4carhire.
3) World MasterCard, gold or platinum from some banks still provides full CDW coverage for Ireland.
4) If you want to waive CDW you'll need a letter from the bank/insurance company stating you have coverage.
5) The regular CDW (not "super" CDW) offered by most rental companies, leaves you with a deductible of 750-1200 euros. You can lower the deductible by paying a lot more for different levels of "super CDW."
The last couple of trips I've rented from http://www.budget.ie cost 375euro for the smallest car with std. shift and regular CDW for 3 WEEKS. That's the total cost, everything included, except fuel, for a rental in late September this year. I've shopped very aggressively and that's been the best deal around lately. Remember, rates are higher in mid summer and for cars with automatic transmission.
When you shop for rates, you'll find it difficult to get the real total price, from many companies. There are lots of hidden charges, Airport tax, VAT, license fees, road tax........... it goes on and on, watch out for non-refundable fuel deposits.
Best of luck!
Oh, BTW if you get a World MasterCard or other coverage that's acceptable to the rental company, don't be surprised to find they charge a 25euro "administrative fee" for letting you use alternative coverage.