Do you buy the expensive petrol at the petrol station?

I was refilling my car today, and it occurred to me that I can’t think why anyone would pay extra for the “special” petrol (e.g. “super unleaded”). Does it make your car run “smoother” or something? Or make your engine last longer? How would you know if it had made any difference? Or is it just a scam to fleece rich people?