Three things matter
How hard you push, how far from the axis, and in what direction. A door shows all three. Push near the hinge and it hardly moves, however hard you push. Push at the handle, far from the hinge, and it swings easily. Push at the handle but straight towards the hinge, along the door, and nothing happens at all: \(\theta = 0\), so \(\sin \theta = 0\).
Two ways to read the equation
Group it as \((F \sin \theta) \times r\): only the part of the force at right angles to the handle turns the nut, and it acts at the full distance \(r\). Or group it as \(F \times (r \sin \theta)\): the whole force, times the perpendicular distance from the axis to the line along which the force acts. Both give the same number. Use whichever the diagram makes easier.
The unit
N m is also what a joule is made of, but a torque is not an energy and is never written in joules.