It's good to be researched going into any fight. Sadly, you're going to spoil yourself on story, especially with Coil, going into there, but it will save yourself, and others, a lot of frustration.
Keep in mind, most of these fights are heavily scripted, meaning a monster is going to do something, and if you don't react in a specific way at that specific time, the unforgiving punishment mechanics will make that mistake fatal to the raid. This is why you're seeing people feel that going in to explore it blind is so disrespectful - it costs them a lot of time for someone who knows nothing, to get adjusted.
That said, I find it personally frustrating how some of the more outspoken here are blatantly intolerant of the difficulties newer or simply less informed players are, thinking of little more than themselves in the situation. Though, that's mainly their text painting the picture darker than it is. They likely simply just want to discourage the continual frustration that is failure due to being unprepared and unpracticed. It's hard to keep having to start over for new players when you are trying to advance.
I'm going to do something I haven't seen this thread do for you yet, and link you to a you tube channel where you can go and research these fights.
I prefer MTQCapture. She's funny, she's concise, and she does a good job of explaining mechanics in simple terms so you may be informed as to why you are acting a certain way. However, there are other YouTube guides that may suit your tastes better. This is simply the one our group uses.
As you can see, there are people of all kinds in the game, and of various different expectations, so don't be afraid to look for people who fit your playstyle and play times. Finding a Free Company or Linkshell of people who share your views is the fast track of getting things done in a manner most fulfilling to you.
It may benefit you more to use Party Finder to find a Free Company to join. I can't speak for Hyperion, they're not even on my data server, I don't think. But I can take it on good faith that there are plenty of groups like mine that don't mind taking newer players through older content and helping them learn the ropes. Seeking out those players may be a far better objective than simply looking for one learning party after another.