MM, MC, or MI cartridge

OP so let me understand. Your new cartridge can sound wonderful on good recordings but nothing special on just so so pressings? Sounds like that's what is supposed to do to be accurate to the source. Maybe you need a Koetsu cartridge that is more warm, romantic sounding. Lots of choices depending on what you are looking for. Personally I prefer a more accurate sound.

I guess I’ll have to choose between whether I want sonic thrills or just okay sound with the majority of my collection. I do have a lot of great sounding records.
Ordinarily I listen to streaming. I can spend my analog time now with my good records which really sound wonderful.

An alternative is to go back to my Clearaudio Virtuoso cartridge that I thought damaged, but which now appears to be in pretty good shape. That cartridge sounded fine with most orchestral recordings, and also very good with audiophile pressings. The reason I switched to the Hana was, of course, wanting something better, and the reviews were outstanding.
I don’t think my dealer will take back the Hana.
If not, I would try to sell it.
Not sure of what path I’m going to take now. 
the two arm solution is not for me.

You can always do the 2nd headshell route. I'll be going that way with a Kuzma arm. 

RV, FWIW, if you were happy with the Clearaudio cartridge I'd go back to it in a heart beat! 

Setting up a great vinyl system is as close to rocket science as you're going to get in this hobby. Everything (!) matters. Some things which I've never seen discussed in these forums. 

For example, set up. With cartridges the Stylus shape matters. Conical - simple but not the most revealing. Line contact (micro ridge) very fussy set up wise but when done right its the most revealing. Elliptical - somewhere in the middle. So its easy,  you think, get the Line Contact. Not really, because all of a sudden VTA becomes critical. VTA can be a moving target and 'proper' VTA can depend on record thickness. You can solve this by using different thickness mats or getting a tone arm with exchangeable headshells , or you can get a tone arm with  VTA adjustable on the fly. Or you can get a second TT etc, one set up for great records and one for ordinary ones. This is only one of the many issues you have to deal with if you want excellence.

I'm sure you've got my point, all great stuff for a anal hobbiest, but it can drive  the average user up a wall. (FWIW back in the day I had two TT's, one with a MC cartridge with a line contact stylus (Benz Micro Glider) and one with a MM cartridge (Grace F9) . Lots to play with, too much perhaps for me especially after digital got good legs. My experience with my vinyl recordings validates your findings with the Hana. Some were absolutely great, some not so much, and some were dreck.

Which leads to my recommendation - unless you are prepared for an extensive/expensive trip into 'great' vinyl just enjoy what you are familiar with, i.e. your Clearaudio set up.

BTW I'm impressed with your hearing acuity and evaluative ability, especially for an old retired fart. :-) 

Newbee,

 You got that last part right.
 And maybe the rest, too. :-)