At ex-work, SSL certificates expiring was probably #3 in the list of reasons for services being unavailable. It's a really easy thing to overlook in service monitoring.
Since then, in addition to service monitoring, I've taken to calendaring certificate expiration dates ~14 days before they expire. Low tech but I've never forgotten since.
Example: http://exchange.nagios.org/directory/Plugins/Network-Protoco...