Legendary. Even Fallout 4 included this in their game. They fitted the USS Constitution with rocket engines in Fallout 4 and manned by erm, less than stellar robots..

Remove one forward main battery and change it to about 50+ VLS, remove most of the secondary twin turrets and add a bunch of phalanx missiles, remove all of the old quad AA cannons and switch it to CIWS, add a flight deck behind that could most likely fit 4 choppers / F-35Bs and demolish the old island and replace it…