What motivated trig functions for me was writing 5 line BASIC programs as a kid to draw circles, spirals, etc. Realizing that COS was the X coordinate and SIN was the Y coordinate made it all clear.

Unfortunately there's no easy, low-friction way for kids today to do that with their PC.