We'll be traveling from Kinsale via Cashel to fly out of Shannon the next day. What town would you recommend staying for departure from Shannon at 9:00 am (leaving time for rental car dropoff)? We will be staying at B&B's the whole time in Ireland, but I don't guess that is critical for the last night there.
We stayed at the Avalon B&B in Shannon our first night (http://www.avalonbnb.net/). It's about 10/15 minutes at most from the airport. There's not much to Shannon, but we were within walking distance to a pub with great Chinese food (sounds kind of weird, but it's true!). Many people on this board recommend staying in Bunratty. Don't stay in Limerick. That's where we stayed our last night, and it was probably our least favorite town.
Bunratty Castle area is the best place for your last night. It's six miles from the airport, and there are numerous B&Bs on the Bunratty Rd behind the castle and folk park. Across the street from Bunratty castle is a little shopping center, and across the road the other direction is Durty Nelly's, a pub with great food. We stayed at Dunedin Lodge on the Bunratty road.
Check out the Bunratty Lodge B&B. A little bit removed from the castle, folk village, Durty Nelly's, etc., so it's nice and quiet, and it's about 5 miles to the airport as I remember. Great breakfast and nice, comfortable rooms.
On the north side of Ennis is the Woodstock Hotel. It's just off the major highway and took us about 15 to the airport.