English footballing failures are a subject very close to my heart, so I'll do it for the ones of my lifetime.
1. H) Euro 1996 - semi finalists. Group stage (1st Group A): Switzerland D1-1, Scotland W2-0, Netherlands W4-1; quarter-final: Spain D0-0 (AET), won 4-2 on pens; semi-final: Germany D1-1 (AET), lost 6-5 on pens.
An ongoing theme is that the difference between the best and worst tournaments isn't actually that big - there were some very average performances and a big stroke of luck in the quarters against Spain. But beating the Netherlands 4-1 is easily their best result at a post-1990 tournament, and they definitely shaded the semi-final against Germany.
2. R) 2018 World Cup - 4th place. Group stage (2nd Group G): Tunisia W2-1, Panama W6-1, Belgium L0-1; second round: Columbia D1-1 (AET), won 4-3 on pens; quarter-final: Sweden W2-0; semi-final: Croatia L1-2 (AET); third place play off: Belgium L0-2
They didn't beat anyone good, but at the time I thought they were kind of underrated, which had never come close to happening before. They played some decent stuff.
3. L) Euro 2004 -quarter finalists. Group stage (2nd Group B): France L1-2, Switzerland W3-0, Croatia W4-2; quarter-final: Portugal D2-2 (AET), lost 6-5 on pens
Maybe a little controversial to have it above 1990, but I watched a bit of this recently and England were a lot better than I remembered. A narrow late loss to France in a game where they were the better team, then two crushing wins where they played great attacking football. The Rooney injury was a killer, but even with that they could easily have gone through. For all the talk now of tactical failings the team with a Scholes LM+Lampard+Gerrard midfield was at least as good as the 2018 side imo, if a lot less likeable.
4. F) 1990 World Cup - 4th place. Group stage (1st Group F): Eire D1-1, Netherlands D0-0, Egypt W1-0; second round: Belgium W1-0 (AET); quarter-final: Cameroon W3-2 (AET); semi-final: West Germany D1-1 (AET), lost 4-3 on pens; third place play off: Italy L1-2
Granted I was only a few months old at the time, but I'm struck by how deeply unimpressive those results are in contrast to the memory of the tournament, and the highlights suggest a lot of luck was involved in going as far as they did.
5. K) 2002 World Cup - quarter finalists. Group stage (2nd Group F): Sweden D1-1, Argentina W1-0, Nigeria D0-0; second round: Denmark W3-0; quarter-final: Brazil L1-2
Hard one to evaluate really. The performances were a bit functional, but they were the second-best team in the tournament and went out to the clear best team. I guess the last half-hour against Brazil's ten men was so anti-climactic that a lot of England fans found it hard to feel positive about.
6. I) 1998 World Cup - second round. Group stage (2nd Group G): Tunisia W2-0, Romania L1-2, Colombia W2-0; second round: Argentina D2-2 (AET), lost 4-3 on pens
England were decent enough in 98, but in contrast to 2004, I don't think they would have gone much further if they'd got past Argentina, who were clearly weaker than the Holland, Brazil, and France sides they'd have met in later rounds.
7. M) 2006 World Cup - quarter finalists. Group stage (1st Group B): Paraguay W1-0, Trinidad & Tobago W2-0, Sweden D2-2; second round: Ecuador W1-0; quarter-final: Portugal D0-0 (AET), lost 3-1 on pens
Easily the worst of the Sven-era tournaments, and the one that colours the memory of his whole reign. The football was turgid, the team and media were at their most obnoxious. England winning any tournament would be a travesty, but this might be the one I'd have least wanted England to win.
8.
O) Euro 2012 - quarter finalists. Group stage (1st Group D): France D1-1, Sweden W3-2, Ukraine W1-0; quarter final: Italy D0-0 (AET), lost 4-2 on pens
Funny because on paper this one doesn't look too bad, but Hodgson acted like he'd given up before they'd even arrived, and for some reason - trauma from 2010 maybe? - the media just sort of accepted it.
A stand-out memory of the tournament is Mark Lawrenson being a complete dick on commentary in the QF, bagging everyone constantly like a 13-year-old girl on a family holiday. I wonder if it wouldn't have felt so pathetic if it had been Barry Davies with no co-comm.
9. J) Euro 2000 - group stage. Group stage (3rd Group A): Portugal L2-3, Germany W1-0, Romania L2-3
The win over Germany keeps it safe of the relegation zone, but there's no real excuse for how badly this England side lagged behind every other one from '96-'06. The Romania game especially was arguably their worst tournament performance of the last 30 years, Romania were a very, very weak side to go out to.
10. G) Euro 1992 - group stage. Group stage (4th Group 2): Denmark D0-0, France D0-0, Sweden L1-2
Into the real smellers now, this one I have no memory or knowledge of, but the collective decision to completely pretend it never happened seems understandable.
11. Q) Euro 2016 - second round. Group stage (2nd Group B): Russia D1-1, Wales W2-1, Slovakia D0-0; second round: Iceland L1-2
Strange that 2014 was met with "ehh, what can you do with such **** players" but after this one Hodgson got the full English abuse. Despite Hodgson constantly talking them down, England had a decent squad of players that a better manager could have got something out of. But in their defence, Iceland were a perfectly good side, and the media had no right to expect England to roll them over.
12.
P) 2014 World Cup - group stage. Group stage (4th Group D): Italy L1-2, Uruguay L1-2, Costa Rica D0-0
They had a tough draw, and some might put it higher because they didn't exactly embarrass themselves. But there's just no redeeming feature about this one. Hodgson convinced everyone that a fine-but-not-amazing squad was the absolute pits, which meant he somehow escaped the blame when a series of tactical blunders caused them to bomb out.
13. N) 2010 World Cup - second round. Group stage (2nd Group C): USA D1-1, Algeria D0-0, Slovenia W1-0; second round: Germany L1-4
They got out of the group stage before losing to a truly memorably side, but even so, it really has to be this one doesn't it? The bird perched on the Algerian crossbar, a blatantly unfit Rooney giving the fans a mouthful after his latest shocker of a performance, conceding a goal straight from a goal kick 5 minutes into their first knockout game. This was peak toxic-England-football, a squad with some absolute throbbers and a whopper of a manager, built up by the media only to be mercilessly abused when they failed miserably to get anywhere near their expectations. It was really, really funny.