There's also the question of what result you want.
If you look at a lemon in moonlight, it looks grey. So the question arises when you photograph a lemon in moonlight, "do you want it to look yellow or grey?"
Not to be pedantic, but if you consider a sponge that grows only between 60 and 120 feet depth, it will never in any 'natural' light look red, yellow, or orange. But if you bring it to the surface and expose it to 'natural' light there it might look, for example, bright red. If you want it to look bright red when you photograph it at depth, your best bet is probably a warm-white light.
On the other hand if you are looking at scenes with various colors and want the most spectacular color variation possible, a high-CRI neutral-white is probably your best bet.
If you want light penetration to anything more than 10-15 feet away, you might as well use cool-white, or even blue-cyan because that's all that's going to go that far and come back.
Of course there are a myriad of other conditions or combinations of conditions that would influence what you might consider the 'best' light.