Well the psychedelic effects are more or less proven to be mainly mediated by 5-HT2A receptors, true. Looking at superpotent selective agonists for this receptor and their effects, I'd say that this is also probably what makes for good euphoria potential. I think this also relieves migraines considering that psilocin acts on 5-HT2A as well and this is the #1 thing they have in common.
However it is possible / likely that 5-HT2C receptors also play a role in psychedelic effects, those are the type of receptors that 2C-B and 2C-C work relatively strongly on. Other serotonergic effects probably contribute but I don't know how or if that is understood well at this point.
I am having a hard time getting an answer for what causes "most of the stimulation" because it is a quite vague description. But it seems that beta-adrenoceptor action is significant for elevated heartrate, while alpha1-adrenoceptors mediate vasoconstriction I think. Those combined with dopaminergic action is probably a recipe for *some* anxiety, but I believe a lot of anxiety with LSD to be psychosomatic.
There can be a lot going on and everything takes up a lot of attention to form understanding, all of that tends to make people a bit anxious...
All effects combined give it a very energized feeling, like there is electricity flowing. In my experience if you let go and let this flow, there isn't necessarily that much tension apart from some inescapable physical effects. Any cramping, either literal or figurative, will manifest the resistance of this energetic potential. Aaanyway this paragraph is where science is dropped.