I personally do not like to be needed, emotionally or physically anyway. I would prefer that everyone had the ability to be completely independent in those ways (in the simplest forms anyway), but that they just like having me around.
Being needed in my job/profession on the other hand, would be nice just for job security.