I'm not sure that any of them are actually wierd - the surrounding logic is always there, any wierdness just comes from unfamiliarity.
It took me a while to get used to XQuery, and the way trying to change the value of something failed silently, but once I got used to that I came to like it: Java feels like it's cheating now, although I know it's just being procedural.
XSL is still pretty unusual, I must confess, but it's like hanging out washing. Once you know how it's supposed to go it looks right when it is and wrong when it's not.
RPG was a little bit strange, but when we lived in a world of coding forms it made sense. Once upon a time I worked for a while with an IBM machine called a 5280 which one programmed in a language called DE/RPG which was like RPG but with extensions. The 5280 had several processors in it, and you can imagine what sort of contortions RPG went through to make sense of that.
COBOL - no, COBOL always made perfect sense. Even with screen sections in it, it always made sense. Back in the '70s I made a whole accounting system for a range of machines from Data General in an interactive COBOL.
APL is probably the closest I've come to complete incomprehensibility: being able to compress a whole program into a single line is an impressive feat, even if it does take two days to unpack it far enough to be comprehensible.