if you make a new spot how long does it usally take them to delete it or how long should you wait to see if its gonna be deleted?

It depends how useless or against the rules it is. Which means: duplicates, hate-clubs, self promotional clubs and other.

AND how many of and how fast other fanpoppers realize that and report it. :D

it depends on how many people report it or if the fanfour come across it my friends spot was up for over a year and was suddenly deleted and we have no idea why (it was a spot for him but i made it ) so its completly random but if its not a hate spot or a self promotional spot it should be okay
if your worried if its a duplicate you can always search fanpop to see if the spot comes up

it can be deleted within an hour or two If a spots name is too much like others they will either merge it with another spot or delete it completely

link

learn more aboot reporting

and the process is not automated so sometimes it might be hours, sometimes weeks, sometimes years..its lyk one of fanpops mysteries