If you have third party insurance on your own car and YOU cause an accident - it pays for repairs only to the other car, not yours.

Comprehensive insurance (or full cover) would pay for repairs to both cars

This is true in the UAE as well. Third party protects others not ourselves if we cause the accident.