As Europe's premiere football competition, the UEFA Champions League brings with it both the the elation of realising dreams as well as the heartbreak of failure.