I think they can be really add to a novel if done right, a good metaphor or simile can help set the scene and make the writing more evocative. It can also be a nice, subtle way to give the reader some insight into the POV character’s emotional state without being too direct.

That being said, a bad metaphor really sticks out and makes the text actively worse to read.