It is named after a person. Mike "Coney" Island opened the first hot dog stand in Detroit in 1850.

Obviously I made that up. I do not know why they are called Coney Islands nor do I care much about the history of them. To me its somewhat of a mystery that I would want it to remain a mystery.