This 2006 feud was basically an excuse to turn HHH face and capitalize on some nostalgia. As far as The Spirit Suad goes, their whole purpose was to be jobbers, comedy jobbers but losers none the less. McMahon was never going to win this feud and The Spirit Squad were created to take the brunt of that.
The comedy aspects were lame, worse yet when you consider they were done by two 45 yr old men, as has been often pointed out.
If anything I was afraid this might go on forever when the Suad tried to eliminate Flair to get back in Vince's good graces. Thankfully that ended quickly when Flair beat the entire squad himself at Survivor Series then teamed with DX to beat them again on RAW, this time mailing them back to Vince's house.
Yes, while I respect the work of many of the participants, this feud, with two 45 yr old juvenile delinquents teaming with a 60yr old ageing womanizer to battle a group of sissified male cheerleaders and an even older 60 plus yr old non wrestler, not my idea of a great feud.