Finally decided to have a play with a mesh deformer. Decided to start simple and try a sine deformer. I got the offset wrong to begin with but managed to fix that up later on.
Fist go:
Adding a weightMap to the mix:
Adding a locator for rotating / moving the effect