So far, I've only had to deal with one major fungus gnat infestation and spider mites. Fungus gnats got out of control 3 years ago. I think it was a combination of things - I used the usual potting soil, which comes with some gnats and that's not an issue in most cases for me. But I was rooting a bunch of cuttings in the middle of winter and got a false sense of security from using the damn gnatrol.... well, that didn't end well. However, 3-4 sprays with pyrethrum at 3-day intervals took care of all of them. Normally, I just use yellow sticky pads, and that's enough to control them. I see one or two flying around here and there, but they aren't an issue. I also have a tennis racket zapper that I use to hunt them, which is always fun.
The spider mites were a bit more of a challenge, but as long as I am proactive, they aren't a problem. This season, at the very beginning, I inspected all of my actively growing plants every 3 days... sure enough, I found a small spider web and some mites on my Vince #3. I sprayed it and all other (young) plants that were in the room with a mix of sulfur, castile oil, and 2 drops of Dawn dish soap 5 times at 3-day intervals. Then, for good measure, I gave Vince #3 an 8-hour pure CO2 bath... it's been exactly a month, and I haven't seen any pests on it. So far, so good.