Next to the prop is the worst seat. Noisiest and most hazardous incase of prop failure or landing without gear on one side. If in doubt, google PenAir Flight 3296 at DUT.

Down the back is best for noise, but freight and pax load cause last minute pax shuffling to get the weight / balance correct -especially for departure.