I am currently a user of CA's SPectrum and NSM tool set and would like to know
1) Whether there is functionality within Solarwinds products that provides similar capabilities
2) Which modules would I require?
Yes, there is for sure products we have that will provide you what you are looking for. Have you looked at the Orion product family?
http://www.solarwinds.com/products/orion/
To get you started I would recommend checking out Orion NPM and Orion APM Module. There are online demo's for these products you can look at and if you want, all our products are available for a full featured 30 day evaluation from our website.
We also have additional modules for Netflow, VoIP, IP Address Management and Network Configuration Management, depending on what your needs and requirements are.