The basic "family" of trigonometric substitutions uses the definitions of trig functions to produce a ratio $ \ \frac{x}{a} = \ $ [trig function] $\theta \ \rightarrow \ x = a \cdot $ [trig function] $\theta \ $ , $ \ a \ $ being a constant. The legs and hypotenuse of a right triangle can produce three possibilities relating square roots of the sum or difference of two squared terms:
$ \sqrt{x^2 + a^2} \ $ can only be the hypotenuse of a right triangle with legs of lengths $ \ x \ $ and $ \ a \ $ . It is the usual practice to make $ \ x \ $ the leg opposite the angle $ \ \theta \ $ and $ \ a \ $ the "adjacent" leg, which produces the ratio $ \ \tan \theta = \frac{x}{a} \ $ , as described above. The associated differential is then $ \ dx = a \sec^2 \theta \ d\theta \ $ ; the radical is then given by $ \frac{\sqrt{x^2 + a^2}}{a} = \sec \theta \ \rightarrow \ \sqrt{x^2 + a^2} = a \sec \theta \ $ .
The other arrangements involve differences of squared terms, which requires the radical to be the length of one of the triangle's legs. We have either
$ \sqrt{x^2 - a^2} \ $ , which makes $ \ x \ $ the hypotenuse; generally, the side adjacent to $ \theta \ $ is chosen as the leg $ \ a \ $ , leading us to $ \ \sec \theta = \frac{x}{a} \ \rightarrow \ dx = a \sec \theta \tan \theta \ d\theta \ $ and $ \frac{\sqrt{x^2 + a^2}}{a} = \tan \theta \ \rightarrow \ \sqrt{x^2 + a^2} = a \tan \theta \ $
or
$ \sqrt{a^2 - x^2} \ $ , making $ \ a \ $ the hypotenuse; the side opposite to $ \theta \ $ is usually chosen to be the leg $ \ x \ $ , giving $ \ \sin \theta = \frac{x}{a} \ \rightarrow \ dx = a \cos \theta \ d\theta \ $ and $ \frac{\sqrt{x^2 + a^2}}{a} = \cos \theta \ \rightarrow \ \sqrt{x^2 + a^2} = a \cos \theta \ $ .
$$\\$$
Returning to your integral, the "tangent substitution" (with $ \ a \ = 1 \ $ ) produces
$$\int \ \frac{1 \cdot \sec^2 \theta \ d\theta}{1^2 \cdot \tan^2 \theta \ \cdot \ 1 \cdot \sec \theta} \ = \ \int \ \frac{\cos \theta \ d\theta}{ \sin^2 \theta } \ , $$
which can now be completed through a "$v-$subsitution" , $ \ v = \sin \theta \ $ , yielding the result
$$\int \ v^{-2} \ dv \ = \ -v^{-1} \ + \ C \ \rightarrow \ -\frac{1}{\sin \theta} \ + \ C \ \ \text{or} \ \ -\csc \theta \ + \ C \ . $$
[Maybe this was already clear to you, but you also seemed to be asking about the rationale for the choice of particular trig functions...]
Referring back to the associated right triangle, the side opposite $ \ \theta \ $ is $ \ x \ $ and the hypotenuse is $ \sqrt{x^2 + 1^2} \ $ , so the "back substitution" to return to a function of $ \ x \ $ gives us $ \ -\frac{\sqrt{x^2 + 1}}{x} \ + \ C \ $ . (I believe you have omitted a radical in your expression; a check against WolframAlpha confirms this...)
Were we to simply construct a right triangle with the legs and hypotenuse described (and thus $ \ \theta = \arctan \frac{x}{1} \ $ ) and ask for the expression representing $ \ -\csc \theta \ $ , we would obtain this same result.