I'd like to create an eq filter sweep similar to this video: https://www.youtube.com/watch?v=t0avJ7X2sDk.
 
What stock eq would you use and how do you automate it like in that video?

any EQ with a resonant filter built in or any other EQ with multiple bands that you can shape like this resonant filter ...
 
you could even do this with the ProChannel EQ, but you would need 2 or 3 bands to form the filter shape you would like, then group the frequency knobs with a quick group and it becomes one common filter

I actually wouldn't use an eq for that, I'd do it the easy way.
 
All that effect is is a filter sweep with a high or moderately high Q, peak or presence, whichever term you prefer. It's been around for decades...
 
Pick a synth that can process audio input that has a filter with a Q setting that makes it whistle or whoosh when played (i.e. the filter resonates). Then back the Q off a bit. Then automate the filter frequency using track automation or an LFO in the synth itself. As well as automating the filter for the main frequency swoops try faster, more gentle modulations of the filter frequency at the same time. Same goes for the Q.
 
The most commonly used filter type for this is a high-pass, but bandpass and lowpass can do interesting things as well. The high Q generates that peak at the filter frequency, then the filter's rejection of frequencies outside it's setting makes the steep fall off.
 
Sometimes feeding a little white noise into the filter with the audio helps, sometimes it doesn't.
 
Waves' One Knob Filter is pretty good at this sort of thing and is often on sale.
 
The traditional tool for this kind of thing would be a voltage controlled filter which doesn't suffer from the "stepping" you might hear with a MIDI controlled one as the frequency increases. The "automation" then being done either with a control voltage source (e.g. an LFO) or by a human turning the relevant knobs.

It seems that you can do this with the Sonitus EQ, similar to what the video shows. 
 
Setup the shape that you want in the EQ and drag it around with the track's "Automation write = ON" during playback.  The EQ band shape will follow the automation that is recorded.
 
It seems that the freeware Melda MEqualizer is a little easier to do this with.
 
If you have the Pro Channel Track EQ, this can also be automated.
 
Good info here:
https://www.cakewalk.com/...elp=Automation.01.html
 
Automation Read and Write Buttons
https://www.cakewalk.com/...elp=Automation.06.html
 
Automation Lanes
https://www.cakewalk.com/...elp=Automation.08.html

If this is a question about SONAR Platinum, try BiFilter2 instead of an EQ.

scook
If this is a question about SONAR Platinum, try BiFilter2 instead of an EQ.

that's one I completely forgot about, thus never tried until now ... well, it would be a good tool for the job but it does have a problem with automation (GUI does not reflect the changes to the filter from automation curves e.g. freq sweep, although clearly audible) EDIT: I just reopened the project where the GUI did not follow the automation and now it does, no clue why it didn't earlier ...

I think that most answered the title of the post correctly, "how to create an automated filter sweep".
 
But the OP did ask the question "What stock eq would you use and how do you automate it like in that video?".
 
An EQ sweep is not a filter sweep, but it is an interesting effect.

Got this working with Platinum. an automated sweep using both Tone2 Bi-Filter and LP-EQ.  The LP-MB is also fun to play around with in this scenario.
 

So someone has now attached their name to a bog-standard effect? I didn't know you could do that. Cool. From now on, please refer to static high-pass filtering as the "Bitflipper Effect".  I will leave naming rights open for compression and reverb.
 
Serious answer: literally any EQ with a "Q" or "resonance" setting can do exactly what's being demonstrated in the video. However, I'd suggest biFilter2, as this is just the kind of effect it was designed for.

If you really want to get into filter sweeps then The Drop by Cytomics is a must-have. A little pricey but it has some very well done simulations of classic filters that sound absolutely awesome when you sweep them with resonance. You can also set up LFO's and envelopes and apply FM to the filter. Loads of fun and sounds great.