I love the isolation of Cliftonwood -- the geography of it, with its solid boundary of Clifton Vale to the west and Jacob's Wells Road to the east mean that you tend not to be in Cliftonwood unless you've got a reason to be there. It's not a cut-through to anywhere, at least not from side-to-side, and you can only really exit to the south on foot.
I sense that I'd be happy living in Cliftonwood -- like my bit of Hotwells, it's a quiet little area with a sort of quirky feel to it. Plus it contributes the colourful houses that are the backdrop of about half of all Bristol postcards ever made :)
I found the "secret" garden especially interesting, just for the fact that it really does feel quite secret, despite the obvious name on the gate. I've lived a half-mile from it for twenty years and I don't think I've ever noticed it before, despite exploring the area a few times.