One of the options presented when trying to join a full server is:
Auto-Retry → Alert me when a player slot is available on the server
I have, however, never really received any kind of alert from this service. Am I looking in the wrong place? Do I want to use Steam's server browser rather than the ingame one, perhaps?