After looking at the post you suggested, I dug a little deeper and ended up reviewing the APlayerCameraManager class (APlayerCameraManager | Unreal Engine Documentation). This had exactly what I needed.
All I had to do to get my desired camera effect was create a Blueprint subclass of PlayerCameraManager, update the PlayerController to use the new PlayerCameraManager instance, and then adjust the value of ViewPitchMax inside the PlayerCameraManager from 89.9 to 0. Now the camera stops just above the ground. Thanks for pointing me in the right direction.