Explain the concept of the Halting Problem and its significance to the theoretical limits of computation. Discuss why there exist problems that are fundamentally unsolvable by any algorithmic process, regardless of advances in hardware speed or parallel processing. Provide examples of non-computable functions.