My kids weren't afraid of their own flushing because they knew when it would happen, and they were 6 so not that little.
But they would hold their hand over their ears in fear of the other people's flushing toilets. It was like torture getting them to wash their hands, so bring extra hand wipes for post potty as well.