To have fun making something that others enjoy? To learn how to create a game-thing without making an entire game engine by yourself?
People will play your mod, so learn to enjoy the feedback you get, and how to grow from it. Don't try to be "the most popular", or else there's really no point...