I think ‘Love Hangover” would have been just as big a hit with say Donna Summer on lead, so the production must take a huge chunk of the credit.
I certainly think Diana lends the song a fun element, but have always been disappointed in live versions where her delivery is never breathy enough, with a tendency to camp it up.