Either Cyper WSP or Talstar P would work for your needs. Both are labeled for roaches and spiders, both can be used indoors and outdoors and both are safe for pets and children when used as directed. They are both great general insecticides, just different in their formulation. If you are treating indoors, Talstar P may have a slight advantage in that it will dry clear, whereas the Cyper WSP may leave a white residue behind on some surfaces.
Termidor SC is a non-repellent insecticide. This means that ants and other insects cannot tell that it is there and they will readily walk over treated areas. Termidor SC also has a delayed reaction time and a transfer effect which allows the ants time to get back to the colony and spread it around before they succumb to the effects of the product. Talstar P on the other hand is synthetic pyrethroid which many sensitive insects such as ants can detect. Ants may avoid the areas treated with Talstar and those ants that do cross over treated areas are the only ones that will be killed by the product. Talstar P does not have a transfer effect so it will not be transferred back to the colony. While the Termidor SC will not actually be deactivated by Talstar P, it will be much less effective if it is over-sprayed with Talstar P.
You can spray the Talstar P higher up around window frames, window sills, door frames, any cracks and crevices around foundation or where caulking around windows and doors has opened up, around vents leading inside, and around lights (these bugs are attracted to the light from windows, doors, etc).
Neither ExciteR or Talstar are true repellents to keep insects away. The area will only be slightly repellent for maybe a day after an application with these. Talstar is designed more to provide a long residual to continue to kill those insects that contact a treated area. Mosquito Barrier is an option that can be repellent for up to 24 hours or up to 30 days.
Talstar P is not labeled for use around edible plants, so we do not recommend using it around squash or other vegetables. Since we do not sell Capture, we cannot comment on the use of that product. We do sell many other insecticides that can be used around edible plants, which you can browse on our site here.
Talstar P is a liquid concentrate that must be diluted with water and applied using a hand or backpack pressurized sprayer. Talstar should be applied only as a spot or crack and crevice treatment indoors. Please refer to the product label for complete mixing and application instructions, as well as the required protective equipment. If you are applying inside a school, be sure to check with the governing authority on what products are allowed to be used in that environment.