Well, like I said, I find it to be nice and quiet but my sump is in the basement where I don't have to try to live with it. There is a hum but when I'm working down there I don't really notice it. If you covered it with a stand and used flex PVC, it might be very quiet but I hate to speculate.
Tanked, upsizing the plumbing isn't necessarily about flow rate. You are probably right that a MAG12 would run fine on 3/4" pipe. However going larger has some advantages, such as less restriction on the pump, especially with long pipe runs. This creates less back pressure on the pump, which in turn extends the life of the pump by not making it work so hard. It will also likely use less wattage thereby generating less heat. There is a point of diminishing returns where there is no more benefit to going any larger and costs significantly more to plumb. As a rule of thumb, I generally go at least one pipe size larger than the output size and depending on the pump and plumbing, might go even larger.