For a long time I was a cassette deck holdout, but the format's inherent flaws, the fact that I hardly recorded anymore, and lack of rack space forced me to give up my 3-head Yammy deck nearly two years ago.
With a good deck and a good tape, cassettes can sound very good. In fact, I made recordings with the old Yamaha deck that rivaled, at normal listening levels, the CD source. Yes, the difference was there, but many of my non-audiophile friends could not tell the difference in A-B comparisons.
My favorite tapes were the Maxell MX-S and TDK SA-X. Sony used to make a ceramic shell tape called the Metal Master -- some refer to it above -- that was the best I used, by a slight margin over the TDK MA-XG, but also cost over $10.00 a cassette. It was also very heavy. Between TDK and Maxell, I thought Maxell had better cassette shell designs, but that TDK's tape was better -- fewer dropouts, and able to handle greater recording levels without overloading. Hence my general Type II tape was TDK, and my general Type IV tape was Maxell. The old Sony ES Metal tape was good too. Note, though, that all my recommendations are based on early to mid '90s formulations and construction. I would imagine that the general lack of interest in cassettes as a recording media means lower quality control from most of these manufacturers.
Too bad, it was much more fun to adjust bias settings and recording levels with the headphones plugged into the deck, trying to get the sound just right than it is to clone an MD from CD.