Three people have died after a siege in a Sydney cafe came to a dramatic end yesterday when armed police stormed the building.