Here are some original old school D&D modules that should be easy to find and not cost you an arm or a leg if you buy them online:

I1 The Forbidden City (TSR, 1980): Old school AD&D sandbox setting in a "lost" jungle city inhabited by snakemen (yuan ti), frogmen (bullywugs), and lots of other weird and dangerous creatures. Lots of room for development here and no two adventures will play alike (due to multiple adventure paths and foes).

B4 The Lost City (TSR): This old school original D&D module consists of a pyramid buried in the desert sands which holds various degenerate groups battling each other for control of the underground empire.

X1 Isle of Dread (TSR): Lost island sandbox setting with lots of different adventure ideas

WG4 Lost Temple of Tharizdun (TSR): written by the master himself, EGG, this AD&D adventure takes place in a long abandoned temple to a dark god hidden in a mountain valley. Initial conflict is against monsters who now inhabit the structure, but if the party delves deep enough they will run into Things Best Left Undisturbed.....!

Axe of the Dwarvish Lords (TSR): This AD&D supermodule written in the 90s takes place in an long abandoned Dwarvish citadel now inhabited by an army of goblins.

Gates of Firestorm Peak (TSR): This 90s AD&D module takes place in a weird, otherworldly mountain that has connections to a "Far Realm" of madness and insanity. Sounds like it would fit right in with Raggi's stuff!

Not as easy to acquire are the classic Judges Guild modules Caverns of Thracia and Dark Tower (however, the 3.5 reprints should be a lot easier to find and are backwards compatible). Both are great and concern ancient, underground empires with lots of evil things lurking about.

That depends on your definition of "illogical." While I've personally never been a fan of Vancian magic due to cognitive dissonance ("It's like only being able to use the quadratic formula once on a test!"), there are in-fiction explanations for it.

Spell Preparation

What's important to understand is that the spells are not simply memorized, recalled, and then forgotten. They are specifically prepared, and then expended. The wizard remembers how to cast the spell, but is no longer prepared to do so.

"Memorizing" a spell is a misnomer. "Preparing" is the more appropriate word.

I don't have core rulebooks for D&D floating around at the moment, but this quote from the SRD says enough, I think:

[the prepared spell] remains in her mind as a nearly cast spell until she uses the prescribed components to complete and trigger it or until she abandons it.

In other words: during spell preparation, the wizard performs some ritual that "casts" his spells into the ether. He can either "cast" the same spell many times, or spread his allotment out over many spells.

Later, he performs some action (specified by the spell) that triggers the spell. That particular "casting" of the spell is completed, and is no longer available until the wizard is able to prepare it again.

In this way, the spells follow an internally consistent model, without relying on what the wizard should or should not be able to remember.

The Metaphor of the Surgeon

Suppose we use a surgeon in place of the wizard, and performing surgery in place of casting spells.

Spell preparation for our surgeon would be the act of preparing his tools: sterilizing them, arranging for the proper facilities to be made available, scheduling staff, and so on.

When the surgeon runs out of prepared tools, he can no longer perform surgery. He hasn't forgotten how to perform the surgery, but nonetheless, he is unable to proceed until he's had a chance to prepare again.

If the surgeon prepares tools for a single surgery, he can perform surgery once. If he prepares for two, he can perform it twice, and so on.

The Man Himself: Jack Vance

What discussion about Vancian spellcasting would be complete, without some input from Jack Vance himself? The following are a number of descriptions of spell casting, all taken from Mazirian the Magician:

On memorizing spells:

...They would be poignant corrosive spells, of such a nature that one would daunt the brain of an ordinary man and two render him mad. Mazirian, by dint of stringent exercise, could encompass four of the most formidable, or six of the lesser spells.

...Mazirian made a selection from his books and with great effort forced five spells upon his brain: ...

On having used a spell:

...The mesmeric spell had been expended, and he had none other in his brain.

On having spells at the ready:

"You may in any event, Mazirian. Are you with powerful spells today?"

I have yet to see Vance refer to the spell casting process with the terms "memorize" and "forget." So far, it's always been oblique, like the passages above.

I think that memorizing and forgetting is a very reasonable interpretation of the lines above. But I also think that their vagueness is important. When I read them, I think of an other-worldly force that the wizard has to hold ready with some kind of psychic "muscle" (like telekinesis). To me, the spells are "in his mind" in the sense that someone possessing you is "in your mind," not in the sense of memories.

But that's purely interpretation.

Jack Vance vs. D&D

In reading Vance, I found the Vancian system much more appealing than I ever found it in D&D. I've put a little thought into it, and here are some of the key differences that I've been able to spot. Your mileage may vary; some of these might not apply to you.

• Vancian Magic Takes Skill

  Vance's spellcasters take hours of preparation combined with years of experience to select a handful of spells that they can use to maximum effect. It also helps that the author of the story actively wants them to use exactly all of their spells.

  To recreate this on the table-top takes an enormous amount of skill on the part of both the player and the DM. For the player's part, they need to know the spells well enough to make a good selection, need to know the world well enough to know what they're going to encounter, need to be clever enough to make spells fit unexpected situations, restrained enough not to spend spells heedlessly, and patient enough to thoroughly plan and research their upcoming adventure.

  On the part of the DM, the DM needs to present a world consistent with published materials, vary encounters enough that the optimum spell build isn't just "Fireball, Fireball, Fireball, Magic Missile," and find some way to give the players the ability to do advanced legwork without having it take over the plot (because after all, if we wanted to spend an adventure planning the adventure we'd be playing Shadowrun).

• Vance's Spells are Powerful

  In Vance, one spell solves most problems. Attack spells kill their targets. Protection spells render the user invulnerable. Blessings can last days or years.

• There's More to Vance's Wizards than Spells

  Vance's wizards spend a lot of their time not casting spells. Whether they fall back on powerful magic items (on the scale of "I am immune to all magic"), magic-that-isn't spells (there's a number of instances of wizards "muttering counter-curses" or otherwise using "magic" that they haven't prepared), or even engaging in outright sword-play, Vance's wizards have options when a spell doesn't suffice.

• Vance's Wizards are Limited to Concurrent Spells, not Spells Per Day

  This is a matter of "gameplay" vs. "realism." Vance's wizards have a limit on the number of spells available at one time, without easy access to replenish their spells. D&D wizards are limited to the more "gamey" spells per day, with ready access to their spell books.