I'd imagine that a Starship would be orders of magnitude louder and once in the air, nothing would stop the low rumbling noise.
It would be a fun math exercise to calculate an acceptable distance.
If I could catch a "flight" to Australia (from the UK) in the time it takes to fly to New York it would be game changing. Hell even 4 hours to LA would be preferable to the 11 hour flight time + 2 hours either side it takes now.
But assuming 100 passengers and assuming they get the launch cost down to $5MM (as proposed in the article) that is $5000/seat which is easily comparable to a first class ticket.
Further (optimistic) extrapolating with more and more Starships available, the tech becoming cheaper/more reliable as time goes on I could see that price dropping over the decades. Just as air travel changed over the years from being out of most people's reach to being routine I could see something like this supplanting planes for those ultra long haul routes.
https://www.youtube.com/watch?v=zqE-ultsWt0
(And to make this fast enough, probably want those electric seaplane taxis that Harbour Air is getting.)
That said, I imagine that ground effect helps a lot at low heights (like during the landing, and early ascent phase). It could probably help much more by deploying some sort of sleeve/skirt for the booster.
And I guess that if you just want to move your rocket a few hundred meters and don't care for the ground, you could leverage it as well.
Going back to the sleeve idea (which would be like a nozzle for the rocket, a chute or a flying saucer), I would like someone to run the numbers on that. And I always wondered if firing current rockets inside a cannon (or just a trench) would help with initial acceleration (as there is a pressure differential that helps, just like the ground effect).