SpybotSD creates host entries and browser entries to protect you from adware/malware sites so NO it is not useless to just run it periodically. Another program you might consider running periodically is Malwarebytes. See our recommended
freeware programs.
Having two active anti-virus programs is never a good idea because of the performance issues, which definitely seems to be an issue with you.
MSE is the only active anti-virus recommended by this forum as a whole. Some of us use other active AV programs without issues but when your system is slow or getting BSODs it is often recommended to remove your AV to see if it is, in fact, detrimental to your system. So yes, I would suggest removing ad-aware and seeing if your system performance improves.