Actually, you are partly right. It really depends on the style of language. For example, texts that contain a lot of facts, such as legal, scientific, and technical works, are better suited to literal translation, while texts with a lot of adjectives are better served by transcreation. According to Darren Chastney https://darrenchastney.com/services/transcreation/ who does both translation and transcreation, this is a very useful rule of thumb. Personally, I have found it really strange to read a scientific treatise peppered with artistic turns that are overly attention-grabbing, and vice versa - fiction with a literal translation that robs the book of its romantic meaning.