I agree - Ardmore - lovely area, Dungarvan - you wont impress your other half! Waterford city is nice but pretty typical, imho nothing spectacular, unless you travel beyond the city to Dunmore East or so.
On that note, Ardmore would be my choice too. Hope you enjoy.