I thought the purpose of Hub V2 was to automate your home. Most things are going to execute in the cloud anyway. Smart Lights is the exception. Except, Smart Lights has some issues, not least of which is a bug that messes up motion controlled lights. “Non-blessed” smartapps work, which the “blessed” Smart Lights does not.
You can wait until ST fixes Smart Lights, and do without automation in the interim. Or check out Motion Lighting: Motion Lighting. No matter what, if you want motion controlled lighting that works NOW, it’s going to run in the cloud. Once they fix Smart Lights, small matter to remove one and replace it with the other! 