Tyre noise depends on lots of factors many of which will be unique to your car including the condition of the suspension, bushes and wheel alignment. I ditched perfectly good Pirellis from a Merc because they howled like a rear wheel bearing was going and it returned later with Avons. Replaced some worn bushes and all was quiet.
Nothing will be a noisy as the Bridgstone RFTs who's super-stiff sidewalls provide no damping, It's not a factor I should worry about and I'm sure any non-RFT will be quieter.