What is a connotation of cacophony?

The connotation of a word depends how the context of the sentence it is in; generally,the connatation for this word would be harsh or overwhelming.

The definition of connotation is the feeling associated with the word, along with the word’s literal meaning.So it really would depend on context.