Have you read "Y The Last Man"? I've been wondering about that one as well.
I did. I am still not sure why I finished it except for the fact that I had access to the whole thing. I'm mostly meh about it. Don't get why so many people love it.
You may also try anything by Kirkman. The guy's a mine of ideas and brilliant at execution.
And if you want to try a Marvel comic with an ending, try the Ultimate Spider-Man Peter Parker run. It has an ending and Peter definitely grows. There are no retcons or continuity bullshit, it's just splendid writing from start to finish, 100+ issues, and the art is generally gorgeous.
I would also recommend the Runaways volumes, which are few, short, limited and sweet, and Snyder's Batman run, which you can read disconnectedly from the rest of the DC Universe. Court of Howls is great but Zero Year is some next level shit. In fact, there's tons of Batman volumes you can read as one offs.
Also Alan Moore, of course. Superheros with a twist, always limited runs. There's tons of things out there, just let me know what you're looking for.
You're the first person I've seen say that about Y. Any particular reasons you weren't into it? Since it's Vaughan, I'll check it out, but it's always nice to have a counterpoint to something so lauded.
I do really like Alan Moore. Watchmen was the first graphic novel or comic I'd ever read, and I also enjoyed V for Vendetta. I've got the first volume of his Saga of the Swamp Thing on the shelf waiting to be read right now.
With Spider-Man, are you referring to
https://en.wikipedia.org/wiki/Ultimate_Spider-Man? I think I could do Spider-Man if it has a beginning, middle, and end just to give a traditional superhero a try. Batman is a bit less likely because I'm turned off by his whole backstory. For my own background, I'm really into social change and critical theory, so regardless of the horrors of the deaths of his parents, I hate that some rich guy has to descend from on high to fight the crime in Gotham City.
The only superhero I've gotten into is via the current Mister Miracle 12-part series. Besides the disinterest in getting into a "universe" of characters or being dragged through an endless series of conflicts and rearranging of alliances, I'm not a big superhero fan because I don't like much about superheroes, or at least the ones I've had some level of experience with whether in movies or in reading the occasional comic (Batman, Superman, Captain America, Thor). When there's too much earnestness and self-righteousness from someone in a funny costume, I'm turned off and kind of annoyed. Mister Miracle, at least in his current maxi-series, has several on-going internal conflicts and a strong and fascinating romantic partner, and so I'd follow them pretty much anywhere because I'm intrigued by the decisions he makes and where they lead. If you know more stuff of that ilk, I'd definitely be interested.
Runaways! I'd read up on this a little, and it seems right up my alley, though I was going to opt for Y and Ex Machina before this one, but maybe this rec will bump it up.
By the way, I just read the three-part Eugenics series. Oh my. Kind of an unexpected gut punch. Strangely reminded me of the best humanity can offer in contrasting a "perfect" race with our imperfect existence. I definitely recommend it, but it's not for the faint of heart.