My mother has Cox trees. The apples are lovely when they're really fresh.

Best apple I ever tasted was a variety called Pitmaston Pineapple. Yellow, very sweet. I understand it only fruits once every two years, and is therefore never grown commercially.