There is no one right light solution for every possible situation, if there was, everyone would use it and there would be a plethora of renders that all looked the same.  A product is not going to produce 'stunning effects' everytime, no more so than you putting in lights yourself, the lights in sets tend to be set up for the way the product creator tends to do their preferred style of render.  Just my two cents.

That said, there are a number of good tutorials on the basics of lighting out there, that will help with leanring how to do it yourself.

The aforementioned tutorial scene from bagginsbill, there is one at RDNA for the basics of lighting, also one on outdoor lighting with IDL.

Once you learn the basics it is all just playing around.