I'm on PS5 and it varies pretty wildly. It's dependent both on the distance your camera is from your character, but also what kind of surface your character is walking on.

Personally I don't like it, and hope they add in an option to turn it off. I find it to just be obnoxious and an unneeded drain on my battery to keep my controller vibrating every step I take anywhere in the game.