I like both
Connor Emerson and
Connor James Emerson, but I prefer
Conor to
Connor. It looks cleaner and feels more intelligent.
Using
James as the first middle name is good because "-nor" and "-mer-" sound pretty similar so the
James breaks them up a little.