My Bonnie lies over the Ocean is not the same tune as The Eton Boating Song but perhaps the Sexual Life of the Camel can be sung to the former.

Most so-called Bawdy songs have no great artistic merit and are rarely worth writing a new tune for, as there would be plenty of existing tunes which could be pressed into service.

The bawdy song "Violate Me in the Violet Time" does have quite a good tune in my opinion but whether this was specific to the words, I do not know. Unlike some other bawdy songs, which run to many verses (e.g. Eskimo Nell) it seems to have only one verse:

Violate me in the Violet Time
In the vilest way that you know
Desecrate me, savage me, utterly ravage me
On me no mercy bestow
To the best things in life I am cold and oblivious
Oh, give me a man who is lewd and lascivious
To violate me in the violet time
In the vilest way that you know