Living on the North Shore isnt meant to be "exciting", its mainly a residential area afterall, but as mentioned there are still plenty of places such as crows nest hidden around which offer more funky eateries, cafes etc than you can poke a stick at.
St Leonards is not a bad place at all, very close to the city, easy transport, low crime rate etc.