There are many introductory texts on real Lie groups, and many on linear algebraic groups in general, but fewer on the specific case of linear algebraic groups over the reals, and even fewer that try to adequately explain the exact relationship between real linear algebraic groups and real Lie groups. Worse, it's easy to get very confused because words like "connected" and "simply connected" mean different things for algebraic varieties or for the set of real points of such an algebraic variety. Even the notation is confusing (what is meant by $\mathit{PSL}_n$, for example, is always fairly mysterious).
My main question is where can I find a book or introductory/survey article that will build the bridge between real linear algebraic groups and real Lie groups and dispel confusion instead of adding to it.
Here's the sort of thing I'd like to see discussed. First, if $G$ is a semisimple linear algebraic group over $\mathbb{R}$ that is connected as an algebraic variety, it need not remain connected when we pass to the differentiable manifold defined by its real points: so $\mathit{SO}_{p,q}$ or $\mathit{PGL}_{2n,\mathbb{R}}$ is connected as an algebraic variety but has two real connected components (the real identity component, $\mathit{SO}^0_{p,q}$ or $\mathit{PSL}_{2n,\mathbb{R}}$, does not come from a real algebraic group). And the same problem occurs with $\pi_1$ as with $\pi_0$: if $G$ is simply connected as an algebraic variety, it need not remain simply connected when we pass to the real points: so $\mathit{SL}_{2n,\mathbb{R}}$ is simply connected as an algebraic variety but has a non-trivial fundamental group as a real manifold. I'm not entirely sure how one can compute the $\pi_0$ and $\pi_1$ of the real manifold of points of a linear algebraic group over $\mathbb{R}$ that is algebraically connected and simply connected (I know one can get some information from the maximal compact subgroup which can itself be related to its complexification, but I'm not sure I didn't miss some fine print and I'd like a clear exposition of this). I'm even more confused as to what happens without semisimplicity.
If no clear reference like I ask exists, is there at least a table somewhere containing the number of connected components and fundamental groups of the real points of the algebraically connected and simply connected simple real algebraic groups?
PS: I should mention that I'm aware of §14 in Borel and Tits's 1965 IHÉS paper "Groupes réductifs", which at least sheds some light on the matter (specifically corollary 14.5: the group of connected components of the real points of an algebraically connected reductive real algebraic group $G$ is a 2-group whose rank is at most the real rank of $G$).