Do you need wi-fi for game add-ons?

As you probably already know wi-fi is a common term used to refer to wireless internet, so the answer is no, you shouldn't need wi-fi for game add-ons. And any standard internet connection should be suitable enough. For game add-ons you should either be able to buy them on disc from a store or download them via the official site.