I think the right person at the right time can be amazing. But I also worry that the same person can become a crutch and you can end up depending on then too much.
I speak from experience as I found a wonderful man who was the sole reason I didn't end myself at a time when I felt there were no other options.
But then for years I couldn't do anything without him being there with me and telling me what to do.
Now I regret that I depended so much on him and actually hate that he didn't help me do things myself rather than encourage my neediness.
So I suppose finding the right person has its ups and downs.