Gorgeous location, and super friendly people. My wife and I stayed 2 nights and just spent the time reading outside enjoying the incredible view of the harbour.
Littleton is also just a quick ferry over from diamond harbour and you can use your metro card.