This will give you a general idea of how the different 9mm loads behave. This is from Winchester's official testing data on their Ranger Talon series:
9mm+P 124gr(1180fps): (Penetration/Expansion)
Bare Gel: 12.2”/.70”
Through Denim: 13.9”/.67”
Through Heavy Cloth: 13.3”/.68”
Through Wallboard: 14”/.66”
Through Plywood: 13.1”/.65”
Through Steel: 18.9”/.40”
Through Auto Glass: 10.6”/.48”
9mm+P+ 127gr(1250fps): (Penetration/Expansion)
Bare Gel: 12.3”/.64”
Through Denim: 12.2”/.68”
Through Heavy Cloth: 12.2”/.68”
Through Wallboard: 12.1”/.66”
Through Plywood: 12”/.68”
Through Steel: 20.5”/.40”
Through Auto Glass: 9.4”/.48”
9mm 147gr(990fps): (Penetration/Expansion)
Bare Gel: 13.9”/.65”
Through Denim: 14.5”/.66”
Through Heavy Cloth: 14”/.66”
Through Wallboard: 15”/.67”
Through Plywood: 14.8”/.62”
Through Steel: 17”/.45”
Through Auto Glass: 10.8”/.52”
All testing is done in accordance with the standardized FBI protocols. The bare gel test involves 10% ballistic gel calibrated to mimic human muscle tissue. The other tests involve placing various materials in front of the bare gel to demonstrate what it would be like to shoot someone through such materials. After the bullet punches through these barriers it may become damaged /deformed or plugged with material(wood/cloth) which will reduce its expansion capabilities. When a hollow point expands it acts like a parachute reducing penetration. If it is damaged or plugged it may not expand very well which results in deeper penetration with less expansion. The FBI has done continued testing of ammunition for two decades and they take into account the results of actual street shootings and how that ammunition behaved against an actual person and/or barrier. With that knowledge, they still recommend that you use ammunition that achieves a minimum penetration depth of 12” in bare gel. They also conclude that good penetration is always more important than expansion, but as long as 12” of penetration can be maintained every bit of expansion improves terminal damage effects.
You’ll notice that lighter and faster bullets tend to penetrate hard barriers such as sheet steel or wall board better, but they are impeded by cushioning or shock absorbing materials such as clothing, wood, or auto glass. Heavier bullets at a slower velocity are impeded by hard barriers such as sheet steel or wall board, but tend to punch through cushioning or shock absorbing materials such as clothing, wood, or auto glass much better.