Your best bet would be to read specific reviews of each toolset due to all of the overlap and conflicting focus areas.
If you're just looking for an all around organic toolset, then you're fine with Moz, and you might selectively want to do single paid months on other tools like SEMrush and ahrefs to collect additional data.
But, if you do enough work in a particular function (eg link building, or keyword research, or technical SEO), you'll need more than one of them. I personally use Moz, ahrefs, & SEMRush the most from your current list. Screaming Frog is another one that is a must-have agency side. URLprofiler is a strong choice as well.
Decision should be made on what you're doing most of the time. Doing tons of keyword research and technical SEO? Your best bet would be Moz, Screaming Frog, and SEMRush, in my opinion. Doing tons of content creation and backlink analysis? You'd be best off with access to Moz, Ahrefs, Majestic, Buzzsumo, and SEMRush. So - everyone will be different.
Here are what I would call the "generally accepted best features" of the ones you did provide:
- MOZ - Good balanced toolset covering content, offsite, and technical SEO considerations. Link database is smaller than ahrefs/majestic but getting larger all the time, and focuses on higher quality links and less "noise" from spam and scraper sites.
- Ahrefs - Very thorough link database, and some of their newer tools are strong.
- Majestic - Very thorough link database.
- Spyfu - Strong for keyword research & discovery - both PPC and organic.
- SEMRush - Strong for keyword research & discovery - both PPC and organic. I use this one daily.
- Raven - One of the best options for reporting. I think they focus on being a balanced toolset.
- Wordstream - PPC-only toolset to my knowledge, aside from keyword research that could be used for SEO.
These are all generalizations, however, and you're going to have to have a tool budget discussion with your agency at some point. $99 or 199 per month isn't going to cut it for an agency of any size. $499 would be a more reasonable budget cap.