As far as I know the are only 4 classes of modern DD's avaliable in 1/1250, 1/700 and 1/350 scales.
The only ones you can get, that I'm aware of off hand, are the Spruance from Dragon in 1/700, decent kit and a Hobby Boss in 1/1250, I don't know anything about that one. There is a Cyber Hobby 1/700 with Delta III but I don't believe it is produced anymore. In 1/350 Dragon made a decent one and Trumepter makes a fair one, both would profit from PE.
The Oliver Hazard Perry, Academy and AFV Club both make a 1/350. I don't know anything about them.
The Arleigh Burke. Hobby Boss in 1/700 and Trumpeter in 1/350. Both have several ship names. I understand that any of them are a decent kit
And the Kidd, made in 1/1250 by Hobby Boss.
I'm sure there are more but you would need to do some research.
Of all those I would go with the Arleigh Burke.
I have the old Dragon Spruance that I stole for $25 plus shipping on eBay recently and they can still be found for various prices but usually around $40
I hope that helps.