Central London here. Use of siren is very well controlled in my opinion, especially compared to other countries and cities. I find they're used for short periods such as when approaching an intersection.

What's the most disturbing for us are people on on scooters, motorbikes, or cars with modified mufflers or engines and excessive revving. Much more frequent, and they love cruising at all hours of the night.