In the US case I think security foils most attempts through operations before they can get acted upon.
I remember Reagan being the recipient of a shooting though(?)
As for the UK, I’d have to say security services failed Thatcher & co spectacularly when the IRA managed to plant a bomb in the Grand Hotel in Brighton.