With glacial lakes and a killer brewery scene, the US’s heartland has much to offer, Nicola Brady reveals