I wanted to know when judging by myself, what should I look for in the story.
I get you, and I think one of the best things is to read quality books on writing, watch some of the good Master Classes on the topic. Brandon Sanderson's creative writing lectures on youtube are pretty darn good. Jim Butcher's Live Journal is excellent.
It's the internet, people give all kinds of subjective advice that is and isn't correct, so I think your best bet is to learn from experienced writers by devouring their teachings.
But there's to sides to fiction. There's the storytelling side, which in all honesty, you don't need the written word, you could tell excellent stories orally. Which brings me to the other side, the "written medium" by which you tell the story. They're separate and yet interlinked, because there are certain advantages and limitations to the written medium when it comes to storytelling.
I think another thing that has proven to be very useful for me, is just reading stories that you personally admire or find exciting.
And there's another truth that is both sad and not sad. Most people probably won't be able to tell mind blowing stories no matter how hard they try. When you read your favorite authors, these folks are at the top of the pile, and it's great to strive for that level of ability, always be striving for that, but to expect it isn't realistic. Most storytellings, writers or not, just tell average stories, and there's nothing wrong with being average. If you look at some of the classic works of writers, or even very popular works, you will often find they have many, many other stories that were in fact, just average.
Brandon Sanderson is a big name fantasy author these days. I really enjoyed his first Mistborn Trilogy, but in my opinion, the second Mistborn series is definitely more average, maybe high level average, but it's still not mind blowing. So even big name writers don't find that mark and then stay at that level, it's just the nature of storytelling.
I read The Gentleman Bastards books. Love them, but they never blew me away, not once. And yet, I still love those books. So blowing the reader's socks off isn't necessarily always the highest goal.
What kind of writer are you? Do you hope to make that your living one day? Prepare yourself and set appropriate expectations. I think the only way to write fiction sustainably is to write it mostly for yourself, otherwise it just becomes work, and it's way too hard as "work" especially since it doesn't tend to have a payoff for the vast majority of even competent writers. It's just the nature of art unfortunately.
But it has to be intriguing for readers to enjoy while reading, right?
Tell the story you want to read, because what's enjoyable and intriguing to someone else, well you might just find that to be a total bore. Sure, you can maximize your potential audience, but if you're not staying true to your own writing interests, you WILL tire of that. I promise you.
But there are certain craft techniques you can learn to make your stories better without changing who you are as a writer. The previously mentioned resources will help immensely. David Farland's Million Dollar Outlines has a section called "haunting" and "stacking" which is something I've never seen another writer talk about as techniques go. The book is worth it for those two sections alone.