.
I am not familiar with cannibal holocaust or stoneman murders, but your statement is generally correct about nouns-as-adjectives being cast in the singular, and it is the same for Slumdog Millionaire. Millionaire too can function as an adjective of course in other contexts: my millionaire grandfather.
.