You will appreciate top floor,

1. You don't hear chair and table dragging sound, nor people jumping up and down sound (especially got kids upstair), which can be annoying especially happened in the middle of night or early morning.

2. You don't need to face leakage problem from upstair unit, which is quite common nowadays, (due to poor workmanship in water proofing). If upstair owner is not co-operating to solve this (aka refuse to do, as they need to fork out their own money), you can have a nightmare. While for top floor, it is duty of management to do if there is roof leaking problem.

3. You don't need to worry blockage of sewage pipe, the lowest floor people may get sewage water overflow into their toilet if there is clogged pipe.
I saw it happened before, stones, even clothes found inside the pipe.

4. Lesser noise and more windy as compared to lower floor.

It depends, if situation beside highway and in a crowded surrounding, may be yes. As lower floor has many other building, walls etc that act as obstacle for the sound to travel.

Anyway we still need a real actual reading in db to measure the noise.
Every building, surrounding is different to start with, which could affect the noise level.

Water pump is located on ground floor, but mostly in highrise, water is not supplied via pump but from top floor water tank.

The water pump on ground floor is used to pump the water to water tank at top floor, not for individual unit/floor.

Top floor has the lowest pressure based on gravity flow from the top, that's why you get it last.