Is this mostly used to flesh out character profiles?

Tvtropes really just categorizes and explains every possible archetype whether that's character, plot, or just anything that appears in a story. People lose a ridiculous amount of time reading all the tropes. A trope is like a cliché but it's not, because cliché's are hated whereas tropes can go either way.