for a list of all spellbooks available at the vendors and found "in the wild", so to speak, go to Jandrall's site.http://www.geocities.com/jandrall/Wizardry8/spellbooks.htm
now, about retro-dungeon.... the automaps are NOT designed to work inside of them. instead you are supposed to go retro all the way and use graph paper to map them out. 
as far as the red dots go, you have to understand how they "built" the retro dungeons when designing the game. what they have done is layer all 3 dungeon maps on top of one another, in the same manner as if there were 3 levels in the same location. knowing that, combined with the auto map not working for these dungeons, you can extrapolate that the red dots you see are probably monsters wandering around in one of the other retro dungeons.
lethe19