Personally, I find Frankfurt a pleasure, as I do Munich. I only use them to transit from Manchester to Bilbao. The bus rides are always undesirable but the Lufthansa coffee stations are a nice touch. Manchester is much improved these days and preferable to Heathrow and Gatwick. Security standards are high but carried out with a smile.
The worst airport in Europe is Gatwick, in my experience.