My first and only time getting a royal flush was in my weekly poker game with a bunch of friends. I have never had a straight flush other than the 1 royal flush, even online.
Mine was playing Cash games in pokerstars, i remember it I had ThKh i flopped the Jh and the Ah and finally the Queen came on the river, I couldn't believe it, it was awesome because I won the pot against AQo
My first time was recently, I went all in pre-flop with AK for clubs, 10-Q flop for clubs and I completed it on the river, I really thought I was leaving the tournament.