Perfect location for enjoying the night life and an absolutely stunning view. This is a great hub from which to see Cape Town City Centre.
The surrounding streets can be loud at night (as would be the case anywhere in the area), so not the best for very light sleepers.
I would also recommend packing your own pillows if you lean towards being fussy in that regard.