I'm on RedHat 9.0 now here. There's no /etc/rd.d/rc.modules in my box. (when will RedHat stop breaking compatibility with odd paths huh?) but there's in my Slackware box. Anyway, I have my joypad module (modprobe joydev) located at:
/etc/rc.d/rc.local
Try adding your module in there