I've tried NQC and Mindscript(text version of RIS, and available in the SDK), but never found them to be very useful.
I've heard good things about
LegOS, but I've never tried it.
If you're really ambitious the Lego byte code for the RCX is fully documented in the SDK, so you
could write your own compiler.
