If you listen to everyone's opinion on this subject, you will end up confused.
IMO self-leveling goop came into the picture due to the fact that the RV manufacturers wanted a product that would lend itself to mass production. With self-leveling stuff they can apply it very quickly, and for the least amount of material cost.
IMO for private/individual use, self-leveling goop makes no sense. There's other ways, which are more expensive and more work-intensive, which produce superior results.
HOWEVER, I'm not so much referring to rubber/membrane type roofs and materials. I only work on metal or semi-fiberglass or all fiberglass roofs.
I use 3M 4200 Adhesive/Caulk and Eternabond and Sika non-silicon products.
IN other words, some of these things you have to learn on your own. Try whatever you decide to use, and give it a few years.