The Captain Marvel Prelude was my introduction into Captain Marvel comics -- while it's an interesting collection of six comics, it didn't exactly leave me wanting more.
The MCU-set prelude comic itself is basically nothing. It tracks Nick Fury and Maria Hill from Avengers: Age of Ultron until Fury calls for Captain Marvel at the end of Avengers: Infinity War, but doesn't actually add anything to the story (or anything to the character of Captain Marvel or her movie, either). Totally meaningless and skippable.
In some ways, the second comic -- the debut of Ms. Marvel (the name the character originally appeared under) in 1977 -- is the most interesting. It's a throwback to an older style, both in writing and art, and there's a certain charm to it. I particularly liked the use of J. Jonah Jameson and how he's a good foil for Carol Danvers in her civilian form. The exposition is written in a classic Marvel narrator style (similar but not identical to Stan Lee in the original Spider-Man comics) instead of the character's thoughts, the panels are smaller and more text-heavy, and the storytelling is very straightforward. The style is certainly not for everyone, but I found myself enjoying how this issue is able to fit a lot more story into it than some recent comics that are basically just art and character thoughts.
Ms. Marvel #1 from 2006 is the exact opposite -- heavy on the art and character thoughts, but very clearly the first part of a larger arc and therefore comparatively light on story by itself. The character of Carol is much better fleshed out here, and I enjoy this era of Marvel Comics art immensely, but there's something about Ms. Marvel as a character that just doesn't grab me.
I like the character much more in Captain Marvel #1 from 2012, where Carol Danvers is wrestling with the decision of whether or not to take the Captain Marvel name (this is her first appearance under the current superhero name). The art is incredibly off-putting though, there's something almost grotesque about the character designs, and everything is weirdly dark.
Generations: Captain Marvel & Captain Mar-Vell #1 brings Carol and the previous Captain Marvel together for a space-faring team-up adventure. The art is much lighter and a great change of pace, and I like that it's more of a self-contained story. The interplay between the two characters is interesting, and gave me a greater appreciation for the idea of "Captain Marvel" -- the passing the torch from one generation to the next -- than the previous comic did. In that way, the previous one and this one work nicely together.
Finally, The Life of Captain Marvel #1 (from 2018) focuses more on the human side of Carol as she goes to her old family house in Maine and deals with her family's drama. It's a nice change of pace, and the series I would be most interested in reading the rest of. But I didn't like the ending, which looked like a clear attempt to return to the space-faring super-heroics of the other issues.
Overall, this was an interesting slice of Captain Marvel as someone who had never read her comics before. But it also didn't really grab me or convert me into a Captain Marvel reader. I admire that her character is written a certain way, but I just don't really like her that much or find her particular struggles all that interesting. While I was disappointed by the MCU-set comic, I do think this prelude format is a great way to get an introduction to a character for those who are interested.