The consequences of energy-time uncertainty are indeed vast and have been studied extensively in quantum mechanics. As you mentioned, one of the consequences is the existence of zero-point energy, which is the minimum energy that a system can have even at absolute zero temperature. This has implications for the stability of particles and the behavior of systems at the quantum level.
Another consequence is the vacuum fluctuation, where virtual particles pop in and out of existence due to the uncertainty in energy and time. This can lead to the Casimir effect, where two uncharged plates are attracted to each other due to the imbalance of virtual particles between them. This effect has been observed and has implications for the understanding of the fundamental forces in nature.
Additionally, the uncertainty in energy and time can lead to the phenomenon of quantum tunneling, where particles can pass through energy barriers that would be impossible to overcome according to classical physics. This has implications for the stability of atoms and the behavior of particles in a variety of systems.
To address your question about when the uncertainty in position stops, it is important to note that the uncertainty principle applies to pairs of complementary variables such as position and momentum, or energy and time. This means that while the uncertainty in one variable can be reduced, it will always result in an increase in the uncertainty of the other variable. So, the uncertainty in position will never completely stop, but it can be reduced to a certain extent depending on the precision of the measurement.
In conclusion, the consequences of energy-time uncertainty are far-reaching and have implications for our understanding of the fundamental laws of nature. As our understanding of quantum mechanics continues to advance, we may discover even more consequences of this uncertainty that can further deepen our understanding of the universe.