If you don't want to run the agent as root, but need to access resources like postgresql.conf, use ACLs.
If you want to monitor apache httpd, you can try an experimental plugin that uses mod_bmx to talk to apache (the GitHub downloads section contains a binary version of the plugin; you still need to install mod_bmx in httpd).
John Sanda has written a plugin, that can use Clojure files to do the actual plugin work. So if you find writing the plugin code in Java boring, just use Clojure :-) (See also this article from John).
And then of course RHQ 4 DP 2 is out (since start of December).
And last but not least:
The Cool Stuff section of the JBoss community website now has some RHQ wallpapers.