While I've enjoyed attending fusion concerts, I find it rather boring to listen to prerecorded fusion.
I've tried. I've owned many fusion albums. I've seen many more live.
Mystical Adventures by Jean-Luc Ponty is pretty much the only fusion album that I go back and listen to now and then.
That and Journey's 1st album. Which was fusion inspired, but one could debate if it counts as actual fusion.
Journey's first album had one fusion track, Topaz. Aynsley Dunbar was so good in that track, it was ridiculous. One of those guys who could make complex patterns sound super tasty.
Manfred Mann's Earth Band was influenced by fusion, especially Mahavishnu, on albums like Nightingales & Bombers and Solar Fire.
Ponty is probably my favourite musician. Albums like Aurora, Imaginary Voyage, Enigmatic Ocean, Cosmic Messenger and Upon the Wings of Music are musical heaven for me.
Here's some recommended fusion albums for non fusion fans like you ... I won't mention Steely Dan's Aja because you are not a fan ... oops, I just did
Andy Summers - Charming Snakes ... eclectic, accessible, powerful, melodic and dynamic
Bruford - One of a Kind ... would appeal to many proggers
Cory Wong and Dirty Loops ... highly accessible and always badass
Dixie Dregs - Dregs of the Earth ... powerful, highly eclectic, insane playing
Jeff Beck - Wired
Pat Metheny - Imaginary Day ... his most proggish album, and a desert island disc for me.