The Acebot is still there:
http://members.cox.net/randar/bots1.html
Also a nice review-page and lots of historic bot-infos there. Another nice Quake1-mod was DMSP that lets quake-monsters spawn in any deathmatch-map for a single-player-experience (like "Invasion" in UT2k3). You know it was all there before... ;-)
http://wouter.fov120.com/maps/dmsp/index.html