Two cars collide and come to a complete stop. where did all of their energy go?

Most of the energy will be absorbed by the materials that make up the cars, causing them to deform. The energy will also be converted into sound energy, causing a loud bang upon collision. Also, some energy will be converted to thermal energy, which will cause the cars to heat up slightly.