Dave wrote:

Is there any product out there that is simply a motor which rotates a
mounted powerhead, similar to the OsciWave (which is no longer
available)?

Here's one which claims to do so.
http://www.saltycritter.com/pumps/hydor-flo.htm

George Patterson
If you torture the data long enough, eventually it will confess
to anything.