The Yellow Submarine is one of the Beatles songs that is not about the drugs.

One can find a list of all Mehndi songs at their Wikipedia page. They have a full list of songs. This is where one can find a list of all Mehndi songs.

In the related link below is a alphabetical list of their songs.

In a few of their songs, yes they do talk about drugs.

A list of light sensitive drugs can be found in most pharmaceutical books. Many pharmacies will provide customers with a list of light sensitive drugs.