TOP records don't match their live performances but What Is Hip and You Got to Funkifize is a good taste
Di Meola isn't the greatest composer so his records aren't the greatest but as a player, he traded licks with Larry Coryell on a Lenny Whote solo album (Venusian Summer) and just smoked him, name of the piece is Prince of the Sea if you can get that
Vai? For the Love of God (forgot which album it was)
Another band in the genre that most folks don't know about is CAB. Some great players got together in the early 2000's and did some amazing work. Your kids may know them, Bunny Brunel, Dennis Chambers, Tony McAlpine. Suggested pieces are Boogie Me, South Side and Hold On
Mahavishnu? Check out Bird's of Fire and One Word, if not the whole Birds of Fire album
Some more, if I haven't bored you yet:
Return to Forever: After the Cosmic Rain, that's Stanley Clarke on bass but before DiMeola joined (Billy Conners can play too)
David Sancious and Tone: Sky Church Hymn #9 (Sancious played keys on the first two Springsteen albums, which so why the piano opening to NYC Serenade and the organ solo in Kitty's back were way above anything else you hear in Bruce's catalog). He played guitar on this cut, guitar-son should love it)
Jean-Luc Ponty: The Struggle of the Turtle to the Sea, Egocentric Molecules (live version)
Mo Foster: Gil (that's the late great Gary Moore on guitar)
Daryl Struemer: Yin Yang Boogie
Brand X: Cambodia, and so to F .....
Liquid Tension Experiment: Amazing super group band (John Petrucci, Mike Portnoy, Jordan Rudess and Tony Levin) that only made two albums. Try State of Grace and Freedom of Speech
Vinne Moore: Race with Destiny and soooooo much more (no pun intended)
Eric Johnson''s version on Coltrane's Mr. PC
newer stuff?
Vulfpeck: Dean Town
Umphrey's McGee
Mindi Abair: More conventional stuff, amazing woman, try Had to Learn the Hard way and Not Bad for a Girl
Mellow?
Peter Buffett: Trail of Tears
Freideman: Indian Summer
sorry, I get carried away with this stuff. Of course it's guitar heavy and we didn't even hit up Mr. Fripp's King Crimson (stick to the Wetton-Bruford interation for the best stuff) or Yes (Close to Edge entire album for their peak) or Robin Trower (Procol Harum home album, first two solo albums). Maybe some Zappa? (Muffin Man, the whoe Apostrphe album). If you and/or music-sons get one or two new pieces or bands out of this, my work is done
GAS? There's the greatest board ever made: The Gear Page. Costs me a fortune !