I'm not sure what airport noise would be like and I personally have never stayed there, but for a father and son I would go with the Fairfield Inn Bloomington

It believe it's the newest Marriott in the area. It offers a shuttle to MOA, free breakfast and you can catch the light rail to the Twins game