From Bored to Driven: Demystifying Pile Foundation Choices