It is down to personal preference. Staying in Downtown Salem will mean you're very close to all the attractions and can walk within minutes to everything you want to see. Staying further out, in a neighborhood like Marblehead, will offer cheaper rentals and it's still just a 10-minute drive or Uber to Downtown.