hi,
welcome to HK!
like all places, Stanley has it pros and cons - it's very green, flat (ie great for walking the dog or stroller if you have little ones), has all the ameneties you'll need and a great residential/weekend feel to the place AND stanley market is a great place even for the locals! Cons would be that it's a good 40 min bus ride into central (there is only one single lane road you take on the south side until you hit Wanchai Gap Road) or 30 mins by taxi - an important consideration if both you (and your partner) work in central OR if you like convenience and not spending hours commuting. Note even if you drive, petrol costs in HK are steep (a full tank on my 2.8 litre car is about HK$800 and it only lasts me about a week although I do drive everyday) even though 2nd hand cars are reasonably priced.
Good luck!