I think it depends on the race.
If you want professionals and people who really take the sport seriously to compete then yes money is a good idea.
But if you want people to have fun and enjoy the race then no its not a good idea, because then people become obsessed with winning and forget about having fun.