Quick answer: Sprite Renderer → Facing Mode = Camera Position (or Camera Plane). Default Custom needs explicit axes.

Smoke puff Niagara emitter. Sprites all aligned to world Y-up; some look at camera, others edge-on. Default Custom mode picks unset.

The Fix

Niagara Sprite Renderer:
  Facing Mode:        Camera Position     // or Camera Plane
  Pivot:              (0.5, 0.5)
  Sub Image Size:     (1, 1)
  Material:           M_Smoke_Translucent

// For trails: Velocity Aligned
  Facing Mode:        Velocity Aligned
  Length Scale:       1.5

Camera Position is the standard billboard. Velocity Aligned for streaks. Custom only when you have specific math you want; rare.

Verifying

Walk around emitter. Sprites consistently face camera. Without fix: visible flickering edge-on views.

“Camera Position. Sprites face viewer.”

Related Issues

For Niagara mesh LOD, see mesh LOD. For Stateless emitter, see stateless.

Camera Position. Faces always.