In all honesty, while I personally hate that anime, I will admit to liking its ending, if only because I got to see the 2 characters I hated the most die some gruesome deaths.
And this is why I say that many people misunderstood the ending to Death Note, or at least didn't really pay much attention to the details. Near didn't "beat" Light as if he did it on hiw own, even Near himself admitted this. It was with the corabined effort of him, Mello, and the Task Force (alright, well mainly just those few merabers who believed that Light really was Kira after all) that Light was caught. Even though they didn't directly work together, by the end they were all out to find a way to prove that Light was indeed Kira. Also, a huge part of the reason for why Light lost was due to him developing his ego a bit too much and just becoming far arrogant and over-confident. That's why I find the ending to Death Note to be fitting. He lost to an opponent inferior to L, and while I myself would have preferred too see L win, it actually ended up being a far more humiliating end for Light, which pleased me since I really hated Light.
I also personally prefer the manga's ending to the anime's, simply because I found that in that 1 key difference between them, the manga's ending seemed to be a more fitting end for Light, especially with Ryuk directly confronting him when writing down his name in his Death Note. I sitll liked both of them, though, but from what I can tell, people usually seem to be more biased towarRAB what they saw first (but to be fair, that would also include me having read the manga first, and preferring it over the anime ).
As for the movie's ending, I feel that it had the best idea for an ending, but I personally felt that it could have been executes a little bit better. Well, IDK how to put it, but for me, the movies would have worked out much better if it didn't seem like everyone was ridiculously over-acting their parts.