Whoa. whoa. If you didn't like it, it's fine :V No need to argue with your self
I didn't like the 7th anyway, coming from a Star Wars fan who watched all the movies. It's basically a retarded version of the original trilogy (the 4th-6th) since ya know, it's been a long time since the original came out and they thought the series needs to be rebooted for the new generation. Also, we live in a time now where one complete story equates one movie. The original trilogy was like a whole story split up in to three movies which actually gave you alot time to get to know the Characters.
And, I feel you. But to me, the grim you are talking about works very well if the plot has an actual depth and you get attached to the characters first. Otherwise, it'll feel like being shoved into you. In this scenario, the fact that the plot was supposedly; a person, with no actual motivation on doing so, is trying to save the world from a complete evil (She was just dragged out of her dwelling) the plot was basically that. The Characters, on the otherhand, too much Characters introduced in one go made it hard to get to understand them individually and even so, they're too one dimensional to relate to. Rey, for example, was basically just a good gal who knows how to kick some butt. (She was still awesome) That's basically her almost complete personality description.
(Sorry for rambling again but I really just like good believable Character Development and deep woven plots . That's how I rate literature.)
As for the Final Shot, I did find it weird but just weird not bad. Also, connecting to character development (Spoiler #2: The sudden change of heart of Rey from just wanting to return home to suddenly wanting train under Luke with no good reason stated was appalling)
On Star Trek, I haven't watched the new one yet so no spoiling for me :V but one of the things I liked in the two movies that I was before that was the Personality Clash but yet bromantic relationship between Spock and Captain Kirk. I dunno if it's noticeable in the new movie you've watched but Spock is the pure Logical Side of the Crew while Kirk is the Emotional\Risk Taker Side. They always tend to clash since polar opposite views yet they spend more screen time having bromance moments together than having screen times with their actual romantic partners.
It's a good thing tho, they're different personality. it kinda brings balance to the decisions made for the Crew. Prevents boring stuffs but also prevents too much recklesness
But yeah explosions xD I really recommend that you watch the two beforehand star trek movies. They're really good (more explosions :3) specifically, the relationship growth between the Crew members and more specfically, how Spock and Kirk became friends and how it develops (I won't spoil anything haha but they originally hated each other badly.) (Also Benedict Cumberbatch was on the Second movie if that means anything to you )