A friend asked me this question and I could not give a good answer. I figure that they might get stressed, but I find no information. Since I find the question interesting, I want to see whether anyone here at RG have any answers or suggestions...
Fish respond light, therefore, they response direction change if the light location change! For instance, some fish are negative phototropic. It means they avoid light. They, thus, naturally inhabit in deep water that are darker than surface water. Accordingly, their feed, feeding behavior and ... adapted. When you light them from bottom, they feel it and sense something wrong. It affect them, but I don't now how.
Great question. In Florida, the underwater lights are gaining in popularity at private docks and these are secured to the bottom and direct upward. It makes the fish much easier to see, but from my observations, the most popular lights with anglers and snook (a popular sport fish) are often those that are just above the surface of the water and point downward. I think the zooplankton are attracted to the surface light and subsequently the bait fish and piscivores might see things easier with overhead light.