The first thing that popped into my head while reading the articles was the phrase "too much of a good thing can be a bad thing". I feel that every relationship is unique so the levels of support vary from couple to couple. The support that I received while in different relationships was always very different from the prior. One in particular was pretty much made up entirely of invisible support. He would do really kind things without being prompted which was great! .....to an extent. After a while it kind of made me want to scream because I felt like I had no say in certain matters, even though it was his way of showing care and helping. I've also had friends who were in very VERY visibly supportive relationships. Their boyfriends were constantly giving them unwarranted advice and trying to give them ways to fix everything. I could see where it would begin to feel almost like the partner is dismissing your issue by saying, "Well fix it by doing this!".
I believe support is key in a relationship's success. Feeling supported makes people happy, happy people generally have happier relationships! It may take a bit to figure out the level of each kind of support each person needs, but once the right combination is found the relationship is sure to be much stronger.