For the joint between a flat garage roof, and the upstand to the house
wall continuing above, what are the pros and cons of real lead flashing
v.s. the heavy duty self adhesive tape with a coat of primer on the wall?

The advantage of the lead is that it prevents water entering the building at
the join between the wall and roof. The stick on flash band does not have
this useful property.

Christian.