The Old Head of Kinsale used to be a beautiful spot I believe. It probably still is - but unless you can afford the membership or fees for an expensive gold club, you won't see it. I've never seen it myself. The entrance is closed to the general public. Still, the whole area is lovely and there is a spectacular view of the cliff from the public area before the gate.
Here is a link to the golf club website - it shows a nice view of it as an intro: link