I haven't yet done any Great Lakes diving but my dive instructor told me the Great Lakes are awesome for wreck diving. I'm gonna get out there sooner or later, after I get some cold water training.
There's some great tales in Shipwreck Hunter. There's a lot of books on wrecks in the Great Lakes; I have this one and it's got more wrecks than you can probably dive in a lifetime.