When I made my reservations, they said that some of the Superior rooms had Sea View and some didn't. I requested Sea View but they said that the only way to guarantee that was to upgrade to the Executive room. I took my chances and stayed with Superior.
The whole story is that ALL the rooms have WATER views. Some have Sea Views but the rest have Harbour Views!
Their web site says they have "complimentary Wired Broadband Connectivity." They didn't when we were there (June 2007). However, apparently unknown to the front desk staff, the lobby's Wi-Fi was available from our room (218).
The breakfast was good and free and offered 7:30-10:30.
You can't beat the location. No other hotel in Kinsale is ON the water like the Trident.
Here's their web site and here're my pictures.
View Larger Map