I was on the Missouri last year and it looked pretty good. There were limited areas that were accessible though. USS Midway in San Diego is pretty well looked after. Again though not all areas are accessible. I guess with such big ships this is a common problem.
BV