You can also think of the Fourier Transform as a projection (dot product) of a signal onto the space of all sinusoids. That's the explanation that made everything click for me.
However, I believe the continuous Fourier Transform works exactly like that.