i'll forgo the urge to tease you about poser power.  it's also true that pwSurface doesn't help with sss materials in poser.  just because a solution doesn't apply to all applications doesn't make it invalid.

i'm sure someone could make an ocean  prop for d|s, but it would probably have to be loaded with morphs and i don't know if things like  reflection and specular would be handled accurately.  i don't think either of those limitations is at all prohibitive.  i'm guessing there's already a great water shader for d|s out there somewhere?.  for other stuff, here's some links to a couple of awesome looking props by forester i've had on my wishlist for ages.  they're application agnostic, so it's up to the user to give them proper materials/shaders. 

River Rapids Foam Library
River Rapids Flow Around Library
River Rapids Basic Library