Do I need a smart/app-controlled outdoor light?

Only if you want scheduling, color changes, or voice control. For straight security duty, reviewers across r/HomeImprovement and r/homesecurity generally say a good dusk-to-dawn PIR fixture beats a smart bulb on reliability. Smart and RGB options like Lumary and SUNVIE are about landscape ambiance and seasonal color, not pure security.