King Arthur is motivated to turn Storybrooke into the New Camelot because he considers it impossible to return to the former Camelot. He has sinister plans and uses others, such as convincing his squire to drink poison, to ensure his plans remain secret. His ultimate goal seems to be tied to fulfilling a vision of Camelot in a new form within Storybrooke.
For more details, you can refer to the full article here.
Here are some related images: