Am i the only one dat is confussed???

ok, so i have a crush on Light, L, and Near..so i'm conflicted by the end of Deathnote. on one hand i think i'm happy cuz Near won, but i'm mad cuz Light died, but Near was only doing what he was supposed 2, being the next L. L died in episode, like, 25, i think. i hated that, 2. mow i'm all confussed! HELP!!!!! (in order, the picture is L, Near, and Light)