If you like current music and use Spotify, my most played prepared playlist is “Happy Hits!” All upbeat songs! Many of personal playlists are built from songs from Happy Hits.
Some other happy songs for me that come to mind first:
A Sky Full of Stars by Coldplay
Crystal Ball by Keane
This Will Be (An Everlasting Love) by Natalie Cole, from The Parent Trap!
Actually the whole Parent Trap soundtrack. 
I will cry almost every time I’m watching a montage of pictures set to music - whether it’s at a wedding, a graduation, a funeral service - doesn’t matter much what the music. But aside from that I’ll go with Dire Straits Brothers in Arms. That guitar is so mournful.
Did think of two more.
Through the Eyes of Love by Melissa Manchester
Don’t Fall in Love with a Dreamer by Kenny Rogers and Kim Caries
Sad: “Don’t Take the Girl” -Tim McGraw
Happy: “Losing My Religion” -R.E.M.
@BunsenBurner I may never forgive you for this! That Goyte song - yikes!
Maroon 5 - Memories
The melody isn’t particularly sad, as a matter of fact it’s rather upbear but the words get me everytime I hear them, especially during the recent holidays and the events of the last few days.
Here’s to the ones that we got
Cheers to the wish you were here, but you’re not
'Cause the drinks bring back all the memories
Of everything we’ve been through
Toast to the ones here today
Toast to the ones that we lost on the way
'Cause the drinks bring back all the memories
And the memories bring back, memories bring back you
REM’s “Belong” always makes me want to dance around the kitchen.
I love this song but it always makes me miss my S who lives in London. I used to sing it to him all the time when he was little.
I have no idea where or how I found this song, but at some point during my husband’s nearly month long hospital stay post cancer surgery two years ago it became my mantra. It brings me to tears every time I listen to it:
Take You Home by Onyay Pheori
https://onyaypheorimusic.com/track/405813/take-you-home
A few other songs that make me happy and/or tear up:
Drops of Jupiter -Train
Stolen - Dashboard Confessional
(This lyric is why-
“We watch the season pull up its own stakes
And catch the last weekend of the last week
Before the gold and the glimmer have been replaced,
Another sun soaked season fades away“)
Music for a found Harmonium -Patrick Street -
https://youtu.be/PltA5woXKaA
Precious Love -James Morrison
https://youtu.be/J4VVdjfBhnQ
And lately, Noah Reid’s version of Simply the Best
This is one of my “dance around the kitchen” songs (I loosely translate it as "please excuse my burnt casserole I momentarily fell in love with the microwaved broccoli and forgot the dish in the oven - ?):
https://m.youtube.com/watch?v=JDyOo1vIUk0
And also this:
https://m.youtube.com/watch?v=pATX-lV0VFk
Oldies but goodies. 
Also this one for dancing aroun the kitchen:
https://m.youtube.com/watch?v=nej-Dj016Lo
Yes, I truly can dance like the ladies in the video. I do! My cats can confirm it! ? ?
Happy cry and sad cry: the entire CD of Dan Fogelberg Live at Carnegie Hall (1979).
Eva Cassidy – Over the Rainbow and Fields of Gold
Love Noah Reid’s Simply the Best!
Happy-
All I Wanna Do
Soak Up the Sun
Forever (Jim & Pam’s wedding- how can you not dance ?!)
Happy/sentimental-
Always on Your Side
Same Old Lang Syne
Landslide
Teach Your Children
So so many more…
The theme song for Curb Your Enthusiasm always makes me smile!
@BunsenBurner that French song is a song I can totally remember from my childhood with my French mother! Also her dress in that video - so cute!
@BunsenBurner love the links, thank you. Glad to know I’m not the only one who dances around the kitchen.
ALSO I haven’t seen that Pet Shop Boys video in years but I remembered the whole thing the second I saw the cat!
I miss MTV.
OK, this is the thread that got me to re-register (under a new user name) after staying away for two months because of the revised sign-on.
My songs that make me tear up more or less for happy reasons:
Turn Around (Malvina Reynolds) ("Where are you going, my little one, little one . . . ")
My Idaho Home (Ronee Blakley)(the climactic scene in Robert Altman’s Nashville)
A Case of You (Joni Mitchell)
Somebody Remembers The Rose (Whiskeytown)
Kal Ho Naa Ho (Shankar-Ehsaan-Loy, Aktar)
Diguem No (Raimon)
Thunder Road (Bruce Springsteen)
Dancing Cheek To Cheek (Ella Fitzgerald & Louis Armstrong)
It’s not that hard to make me tear up. Obviously.
Also, songs that attached themselves to, and came to represent, old relationships (or old wannabe-relationships):
I Want You (Bob Dylan)
Sundown (Gordon Lightfoot)
Sister Golden Hair (America, a band I generally detest)
The Tracks of My Tears (Smokey Robinson)(the Linda Ronstadt version, too)
The Best Of My Love (Eagles)
Get Down Tonight (KC and the Sunshine Band)
Love and Affection (Joan Armatrading)
Beast of Burden (the Rolling Stones)
My emotional attachments formed in a pretty compressed time range.
My son has never, ever been able to listen to (much less sing) “Puff, the Magic Dragon” without tearing up. He’s 31, and you can still push that button at will.
Hard not to be happy (enough to dance in the kitchen) hearing this song.
Check out the lady in the all-black outfit with white adidas at the 20 second mark.
Wow, she can shuffle!
Unchained Melody - The Righteous Brothers
What does it mean that I haven’t heard of most of your songs?! (I know, I know, I am very unhip).
An achingly beautiful song that is so sad:
Joy Division’s Love Will Tear Us Apart
https://m.youtube.com/watch?v=zuuObGsB0No
I’m listening to it a lot because I heard a BBC Great Lives podcast on the lead singer (and songwriter) Ian Curtis. It’s made me a little obsessed.
One of my sons made me a spotify playlist of all happy upbeat songs. One of my favorites:
https://m.youtube.com/watch?v=7zp1TbLFPp8
Danza Kuduru (the video doesn’t match the song imho)