Exploring new physics frontiers through numerical relativity