Well, in a word, probably not. They're main value is for nostalgia of the old modules.
The ones by Paul Kidd are OK (I'm mainly referring to the Decsent into the Depths of the Earth), though he has a very different take on the modules than was intended. The people and places are basically as written in the modules, but the reason the hero (Justicar, IIRC) goes down into the depths is rather different and invented, IMO.
Also, note that Paul Kidds novels focus around one hero, Justicar, and a few companions such as a pixie, a good hellhound, etc. Not a traditional party of adventureers.
Paul Kidd also wrote Queen of the Demonweb Pits, White Plume Mountain, and I believe Temple of Elemental Evil
Against the Giants was wriiten by another person, I forget the name. I actually liked it somewhat, though the writing was pretty bad. Basically, it was an attempt to put a real D&D adventure into book form. The characters are a standard D&D party, and the attack each of the Giant lairs, and the details are very close to the modules (I really appreciated the author's attempt to do this). However, the writing sometimes came out like an 14 year old describing their character action. ("I memorized plenty of ... spells today" or "We've been Rangers for 20 years") Also, the author tries to cram all three modules into one short novel, and by the time you get to the FIre Giant lair things are very rushed.
BTW, I would love to have Against the Giants done as a trilogy by a top-notch author, but I suppose that's just me.