Those are good questions my anonymous friend. Thank you for asking. Here are my thoughts:
To answer your first question: no, I don't think it appropriates anything. Here's why: firstly, if we're talking about sexuality and gender, it's queer 101 that no one owes anyone a justification of their queerness, and not everyone who is queer is interested in labeling it or making it legible to you, and they have no obligation to do so, and not doing so doesn't make them any less queer. Furthermore, some people who are queer are not interested in sex, so what about them?
All of that together is why, for me, the entire queer project is much more deeply about non-compliance with hegemony, and specifically with hegemony around gender roles, sexuality and to put it under a big umbrella, patriarchy, than it is about who you fuck. Those things extend into so many other aspects of life that I think you can easily talk about "queering" a very wide range of topics, and possibly? ANY TOPIC.
You are responding to this post, I think, and in it, I made a choice to talk about family and hunting, and our heroes roles and characterizations in that, and did not talk about gender shenanigans or sexuality, because my point was that even before we get to anything to do with it, Sam and Dean are immersed in a queered world in a fundamental, structural way. That said, I assure you that if you go back into season 1 of Supernatural, you will find LOADS that could be said about gender and sexuality, too. As well as other things, and a particularly important area, as @ironworked pointed out in the tags, is blue collar/white collar class issues.
As I said, the depth of queerness in Supernatural is actually dizzying just in terms of the story's BONES to say nothing of how they flesh it out. Queerness is about deviation from the norm. It's about rebellion and disobedience against hegemonic systems for the sake of personal authenticity and love.
Think about Cas for a minute. Cas's whole story is that he rejects his role in a hegemonic heaven. He rebels for love, and that is pretty explicit as early as season 4 when he tells Dean "We're making it up as we go". Fellas, that is THE QUEEREST SHIT EVER even if he didn't do it for Dean, and like... HE DID IT FOR DEAN. Cas did not have to tell Dean he loved him for me to know it, and for Cas to be a deeply queered character. When he DID say it, I wasn't the least bit surprised he was in love with Dean, because seriously, we been knew. I was only surprised I got to have the immense pleasure of hearing him say it and looking at Dean's face while he took it in. Jesus. I will NEVER RECOVER.
This is my perspective on representation in Supernatural: It's excellent, and I relate to, and feel seen by it as a queer person. Nobody needs to get fucked on the maps table for me to do the math that this is a queer story. It is very, very, very thoroughgoingly canonically queer in so many ways, and not all of them are to do with sex. I think some fans will only allow it to be called queer if dudes make out in it. I am not one of those fans.
As to your second question, I think there is a wealth of evidence in the filmic oeuvre of Eric Kripke to suggest that as an artist and a writer, he is concerned or maybe even preoccupied with masculinity issues and issues around family, and around the way patriarchy fucks men up. So, yes. I think he knew what he was doing and he knew that queerness was part of the mix. For fucks sake, it's a family of men who hunt monsters. That is very fucking on the nose. Do I think he kicked off Supernatural in 2005 planning a 15 year operatic queer romance between Cas and Dean? No. I don't think anyone planned for it to go as long as it did, and it's a matter of record that some things were influenced by fan response, actors' chemistry, different writers and showrunners' preferences and etc. What I will say is that when they had a choice to "straighten shit out" or lean into the queerness, they fucking leaned in, nearly EVERY TIME. Like, it's pretty amazing how consistently they lean the fuck in.
I'll admit -- I wasn't watching it with those eyes the first time, and I didn't give it much real estate in my mind when I watched it as it aired from 2006 to the end, but the last three episodes reshaped it for me and made me angry, and also made me need to watch it all again, this time with an explicitly queer lens, and BOY HOWDY let me tell you this: the Supernatch rewatch journey is a wild and wonderful trip to Queertown. It is legit more difficult to argue that Dean is straight than it is to argue that he is queer. There is a full on CORNUCOPIA of story evidence to support that read and relatively little that convincingly counters it on the straight side, and that starts right at the beginning, when they bend pretty baby Dean over a police car in episode one, and he smirks insouciantly in his lip gloss. Do I think everyone involved knew how that looked? Sexy, submissive and a bit gay?
