No video needed
Search and Shopping. Between them that is most eCommerce revenue for most stores.
Video helps
Demand Gen — image assets work, video usually works better.
Video required
YouTube campaigns, obviously. And note that Performance Max will generate video from your assets if you supply none, and you will not enjoy the result.
What kind
Not a brand film. Product doing something visible, hook in the first two seconds, offer stated plainly. Phone footage that shows the product working beats a polished ad that does not.