I worked with the local promoter when the national tour or RAISIN came to money. I could never sit through the entire show, but it is basically A RAISIN IN THE SUN with the drama cut off at the knees by the insertion of seemingly random songs. The characters of "Mama" has a good gospel-inspired tune in each act, but otherwise I can't recall a single song. I just found them annoying when they arrived.
The tour played to empty houses in Miami, at least.
***
I don't think Patti Lupone is right for every Merman role. Sally Adams in CALL ME MADAM isn't a moron, exactly, but she's not the brightest bulb on the string either. Merman was great at playing dumb broads, but Lupone always strikes me as craftier than that.
***
The book may be total garbage, but people at another forum recommended MAKE A WISH from 1951. It has a delightful Hugh Martin score and, I suspect, a book that could be easily revised if necessary. It seems to be about Americans in Paris in 1951.