There’s no official list, but the community keeps a list in the following thread:
Also, you probably already know this, but no custom code of any kind can run locally at the present time, and routines cannot run locally.
The only smartapps that can run locally are the official smart lighting feature and some bits of smart home monitor.
The Aeon minimote stock DTH can run locally with the smart lighting feature, so it’s often a good choice for turning things on and off that you would otherwise have turned on and off either with the mobile app or by voice. But you have to set up the minimote ahead of time, you can’t create new automations without the cloud. 