Maybe Sean Connery’s caught coming in drunk (4)
I believe the answer is:
scot
'maybe sean connery's' is the definition.
I can't tell whether this definition defines the answer.
'caught coming in drunk' is the wordplay.
'caught' becomes 'c' (cricket abbreviation).
'coming in' is an insertion indicator.
'drunk' becomes 'sot' (sot can mean a drunken person).
'c' inserted into 'sot' is 'SCOT'.
Can you help me to learn more?
(Other definitions for scot that I've seen before include "Tax, Glasgow native" , "One from north of the border" , "UK northerner" , "Someone from Dundee?" , "Native of country of the UK" .)