Ha ha, I remember that scene. It wouldn't be so freaky if it wasn't so sudden. The music is all quiet as Chuckie looks under the bed, and then a quick cut to a freaky-looking monster as the music starts blaring!
When Rugrats wanted to freak kids out, I'd say it succeeded more often than not.