In the Solomon Islands. Pretty cool:
I disagree with your assessment; that is very cool.
And after reading the Wikipedia entry, it seems to be a textbook example of how a ship’s crew should act during an emergency. Kudos to Captain Oliver Kruess and everyone else who was working aboard the World Discoverer; y’all done good!
Yes, very cool.
Here is one that I have been to, although it’s a bit older and wasn’t quite a “cruise ship”:
There’s another older shipwreck – over 100 years old – in a breakwater near where I live.
My brother and I rowed a small boat from Westport across Grays Harbor to see what was left of the SS Catala, it was beached near Ocean Shores, Washington. We didn’t count on a weather system moving in and ran into some heavy waves trying to get back to Westport. Thankfully a fishing boat came by and towed us back to Westport. This was back around 1972.
I’ve been to the MV Plassy, on Inisheer Island in Ireland. It was interesting to see what it looked like 50 years later. I didn’t go in the thing, though I was tempted to. Probably wouldn’t really hold my weight any more as it’s so rusted.
On a side note, I’m quite impressed by the sea floor topography on Google Maps, maybe I haven’t checked in a long time but it wasn’t that detailed before and it’s quite fascinating to “see” that landscape for the first time.
Here are the remains of the concrete ship off of Cape May NJ.
Cool - thanks, all!
Another one: the wreck of the Peter Iredale near the mouth of the Columbia River. Used to be more impressive.
Goonies!
Psst - see post 3. 
Egad. I thought I had checked all posts, including links. My bad.
If you ride the Galveston - Port Bolivar ferry, you will get a great view of the SS Selma, a concrete ship sunk in the Houston Ship Channel in 1922.
Google Maps view
When I was on Kwajalein in the 1980s, I learned to scuba dive. There are many wrecks in the lagoon, but one of the most famous is the German battleship Prinz Eugen, which was involved in the sea battle between the Hood and the Bismarck. The ship was later anchored at Bikini during the atomic bomb tests. It sank in Kwajalein Lagoon in 1946. It is a fantastic dive to make, as the ship rolled over when it sank and it is possible to swim completely under it.
Google Map view (not very detailed)
There’s another wreck in Mahogany Bay, Roatan Island, Honduras, right next to the cruise ship docks. No idea why it’s never been removed, unless it’s “local color” rather than an eyesore.
Some very interesting stuff here- which got me to searching and I found 48 Eerily Intriguing Shipwrecks. Sorry, no Google Maps links, although that wouldn’t be difficult to find for some of the wrecks listed (a few were already mentioned upthread).
Another concrete ship–not sunk, but definitely out of commission–is the SS Palo Alto in Aptos. It was put at the end of pier as a gambling ship back in 1929. Google earth view
You can use street view to walk around the pier and get a closer look. One good thing about seeing it virtually is that you don’t have to smell the guano.
Sitting in the middle of picturesque Harbour Grace, Newfoundland, we have the SS Kyle. Been in her current, run aground, location since 1967. I beleive she has occasionally been repainted so as not to be an eyesore.
Huh. Very odd to see a former Nazi warship going through the Panama Canal!
Stumbled across another one, purely by chance.
The Sub Marine Explorer is wrecked and rusting away on the beach of Isle San Telmo. It was one of the very first submarines ever built and was intended to harvest pearls. It killed its crews instead because nobody knew about decompression sickness.
Interesting article. Video at the end is really cool.
Google Maps