When I was first endorsed on a retractable my instructor said that 'there are those pilots who have had a gear up landing - and those who will.'
Have been in two aircraft (C210 and B36) which have had undercarriage failures but both 2 greens and one red indications were picked up and the manual procedures worked.
TJW