Northern Wisconsin and the Upper Peninsula of Michigan are both really pretty with some great kayaking on lakes which extend beyond the horizon. I like Milwaukee. There's a neat socialist infrastructure legacy there: https://en.wikipedia.org/wiki/Sewer_socialism