Is Spybot Search & Destroy is a good program to remove spyware and adware?

If not, what program is best?

Yes it is. You can also get Ad-Aware from Lavasoft. SpywareBlaster to keep spyware from getting even on your PC.

Spybot – Search and Destroy