Aqua is a great spot with beautiful rooms. More like a guest house with only a few rooms. However, it gets LOUD there as a popular music venue is really close, so sleep might be an issue. What exactly are you looking for? All places listed have fans for various reasons, so some insight will go a long way.

Also, have you looked at the West End/Cliffs? Great place to stay if you are going with a significant other and want some peace and quiet.