Hi Crickster,
I'm going to assume that you bought an old Q650 and have done nothing to it. The machine is 24 years' old.
First and foremost, you need to either remove (or better still) replace the PRAM battey. It is a 3.6V 1/2AA battery. They can be gotten online for USD10. These have been known to rupture and corrode the motherboard.
Secondly, be aware that your motherboard (and possibly power supply) will need to have its capacitors replaced at some point. As with the PRAM battery, these things were not designed to be working after 24 years. That they still are is a testament to Apple's build quality. The general advice is to wait until something stops working or if your capacitors start bulging. There are are many members here who can help you with this.
From this point on, it is all entirely optional. You have a fine 68K gaming machine. Only the Q840AV is a better 68K machine. The specs that you have are sufficient for a good experience.
1. There is a lot of software available online. There are many ways to get it onto your Q650. My favourite methods are the burning of images on to CD and using Zip disks. You'll need a CD-burner or a USB Zip dive on your Internet computer and a SCSI zip drive for your Q950 as well as the appropriate SCSI cable . A SCSI CD burner is also nice to have for your Q650.
2. 1MB gives you more screen space. If you can get yourself another 512K VRAM SIMM then you'll be able up to get 256 colours at 1024x768, which is good for games like Civilization.
3. Unless you want to run a RAM disk, you don't need more 24MB is more than sufficient. Of course, if 32MB SIMMs come your way cheaply, then take them. Your boot time may be longer though.
4. You don't really need any NuBus cards. If you feel the need to improve the performance of your machine, then a FWB JackHammer or an ATTO SiliconExpress IV will give you 40MB/s LVD SCSI (ooh!). The Thunder series from SuperMac and Radius will allow resolutions greater than 1152x852. If you want 24-bit colour at 1024x768, then high-end NuBus card (like the above mentioned Thunder series) from Radius, SuperMac, RasterOps and so on wil allow this. They won't make game-playing faster but they will allow more colors over more pixels.
5. If you a faster hard-drive, then a U320 SCSI hard drive (say a 9GB or 18GB) with a 80-pin SCA to 50-pin adapter will help you. The drive will be faster, quieter and much, much larger than what you have at the moment. The big advantage to a massive drive is that you can save all of your games as image files and simply mount them on the desktop as needs be. The games will play from the HD and not the CD-ROM. Of course, the U320 HD will run hotter than the old HD, so this is to be borne in mind. Max1zzz (of this parish) has/had some of the adapters for sale and he can be contacted by PM. This works well if you have one of the two LVD SCSI cards mentioned above.
6. If you want quiet, then the SCSI2SD from Michael McMaster is a great option. When i bought mine, it cost me the equivalent of USD75 and then shipping from Australia. It is a SCSI to SD card adapter. Follow the instructions on his website and then you have an SD card as your hard disk drive. It is quiet and at least as fast as the HD that came with your Q650.
7. Big Mess O'Wires (BMOW - also of this parish) has a couple of interesting products. The ADB Wombat allows you to attach a USB device (say, a favoured mouse) to your ADB mac or an ADB device to a USB port on a (more) modern machine. He has a device (Floppy EMU) that you to load floppy images on it and load them onto the desktop of your Mac 512K. His shop is well worth checking out.
8. I, personally, love my Kensington Turbo Mouse. It is a massive trackball and it is ADB. There are many ADB joysticks and input devices. These can make your game-playing more enjoyable.
If you are looking for stuff, eBay is not bad. You can always put out a request in the Trading Post and see if that gets you what you want.