If you only play fighting games on the PS3, you’re pretty much limited to SF4, HDR, and MvC2. CvS2, the Alpha series, 3S, and any other PS2 game will have 3 frames of lag added due to how PS3s handle backwards compatibility. This includes PS3s with hardware backwards compatibility. Although this might be ok for casuals (depending how hardcore you and your friends are) this really isn’t good for serious training.
So of the games you’re left with, but HDR and MvC2 will help with execution. Of the two of those HDR has more in common with SF4. Will there be some execution benefit? Sure. If you can say, Jump RH, Low forward, Fireball with Ryu in HDR, you can pretty much jump right in and do it in SF4. Comboing supers is harder in HDR as well; in the 2 series, you have to pre buffer half of the super motion before doing the normal. So picture: fireball motion, down middle kick, second fireball motion, punch. Although many might think “well, why learn this if it’s the only game it works like this in,” it’s actually a useful technique in some other games (3S for example) for hit confirming supers.
Other things though… HDR is not link heavy like SF4, nor are there FADC combos. I’d personally argue that Viper and Gen’s stuff in SF4 is harder to execute than most everything in HDR, but that’s just me.
So in some senses it will help your execution, in others, SF4 has some game specific stuff you’ll still have to practice.