http://wiki.openoffice.org/wiki/Python_as_a_macro_language#S... has a sample hello world script that can be run as a macro

But I agree in general that the documentation is paltry. Good opportunity for an interested person to do some more digging, write a few blog posts and possibly contribute to the documentation :)