The limits of computers would be the same as the limits for humans. We have no reason to think the human brain has a stronger computation power than a Turing machine.

So, in a way, learning about the limits of computers is the exact same as learning the limits of humans.

But also, learning what the limits of computers are is absolutely relevant. You get asked to create an algorithm for a problem and its useful to be able to figure out whether it actually is solvable, or how fast it theoretically can be. Avoids wasting everyone's time trying to build an infinite loop detector.

Two govt spooks are hunting a dangerous fugitive who is also a humanities graduate. He escapes into a sprawling maze of tunnels. "It's hopeless," one of the spooks says. But the other simply says, "Watch." then proclaims loudly, "studying linear algebra is important because of its use in stochastic processes and image manipulation." Before he finishes the sentence, the fugitive emerges back out the tunnel and shouts, "but what's even more important --" and is immediately knocked unconscious and taken for questioning