Dungeons & Dragons means a lot of different things to different people. It might mean wish fulfillment of getting to be your own Mary Sue. Maybe it means number crunching and being as powerful as you can be (which is wish fulfillment in its own right). Maybe it means escaping reality by doing good and saving the princess. Or maybe it just means hanging out with friends.
I think everyone comes to role-playing games like D&D because it’s the ultimate sandbox in a lot of ways. Depending on who your dungeon master is, the only think limiting your abilities is your creativity—you can do what you want, as long as it’s not impossible within the rules of the world (which may or may not coincide with the rules of the game). “Choices are infinite—consequences are mandatory”.
For me, D&D is about two things. I love the escapism it provides in allowing me to pretend to be people wildly different from myself, and since I’m a storyteller at heart, it also lets me feel like I’m part of a crazy adventure in a fantasy novel than simply writing one.
I feel as though I’m in a weird minority in the community. The vast majority of people I’ve interacted with in regards to D&D aren’t (particularly) interested in the story, or when they are, it’s always in the framework of their character. For me, the story and the character are often two separate entities entirely. I built a character that is fun to pretend to be, not one that has an intricate backstory that has strong connections to the world they live in.
I have a few friends that with whom I share D&D stories on a regular basis. I’ve certainly considered inviting them to the game that I run, but deep down I know that they wouldn’t have any fun. At its current state, the Aleor campaign is a lot of talking to normal townsfolk rather than an epic adventure of heroes and villains, and I can’t accommodate a player who wants to be a Jedi.
Finding the D&D group that you mesh with is tough. Since everyone’s playing for different reasons, the obvious, most accessible group to you may not be the best one for you. It may not even be the right one, and since the type of person to be playing the game tends to be the sort of person who doesn’t make a habit of socializing with strangers, it becomes very difficult to find the perfect fit, because for you that perfect fit might only be online with the help of meetup groups like Roll20.
For me, Critical Role is the pinnacle, most ideal version of what D&D could be. Other streams are entertaining, but in my experience, none of them are stories being told the same way that Critical Role is. If I wanted to mess around and goof off at a table with a bunch of friends, there are dozens of different board games we could play with way less effort. Dungeons & Dragons is the only one that allows me to alter my identity.