I watched TNG all the way through only pretty recently (I only had vague memories of watching single episodes during my teens) and I was impressed with how Riker and Troi's friendship turned out. Really loved it. There was an intimacy there that spoke of knowing each other very well and many occasions where they just supported each other, both in times of crisis as you say, but also when it came to romance. Given how questionably some other things were handled, especially when it comes to Deanna, the show did much better with their relationship than I expected. There were many instances where they could have gone a very clichéd jealousy route with Riker and they didn't. Many points for that.

Agreed on Data and Geordi as well, love that you picked uncomplicated as a descriptor, because that's really what it was: an uncomplicated friendship that was simply wonderful to watch and had me invested when it mattered, like the episode where Geordi searches for his mother.

And I'm also with you regarding all the DS9 ones, that show is basically an embarrassment of riches when it comes to great relationships moments. Dax in general comes across as someone with a real talent for friendships - even Ezri, who I was less fond of, had some great friendship scenes with Worf once they got over their hang-ups, I appreciated that.