In terms of your relationship especially...
I have always been high maintenance. I have somewhat of an issue with it always being seen as a negative thing though. I am not the stereotypical high-maintenance wife who is clingy, nagging, and whiny.
Instead, I appreciate and encourage my husband serving me. We found out early on in our marriage that while I crave being cared for and taken care of, his needs are to be able to care for me and so the majority of the time we have a very healthy balance. Although I will admit I am a negative high-maintenance at times and CAN be whiny or unnecessarily needy. Thankfully my husband is very good at dealing with it and not allowing me to take advantage or walk all over him This was especially an issue while I was pregnant and more emotional than usual.
I think it there are definite pros/cons to being either and it really depends on your chemistry with your SO on whether or not you're compatible with it