It looks like crap if you do that. Really amateur-ish. I recommend never doing that, honestly.
Here's my Mini Leon Belmont's basic walking sprites:
(EDIT: More sprites are available now!)

And here are the sprites as an animation:

SPRITE ANIMATION FRAME STANDARD SIZE = 32x32 (except where otherwise noted)
1A-standing still/walk1
2A-walk2/climbup2/climbdown2
3A-walk3
4A-crouch/landing
5A-JumpForward1
6A-JumpForward2 (for 'outfit waving in the wind action)
7A-Jumping Up1
8A-Jumping Up2 (at the Apex)
1B-Falling1 (After Jumping Up2 and until landing)
2B-climbup1
3B-climbup3 (normally the NES games have only two climbing animations, but I added another one so it now matches CV4)
4B-climbdown1
5B-climbdown3 (same deal as climbup3)
6B-Damage/recoil bounceback
7B-Death1
8B-Death2
1C-Standwhip1
2C-Standwhip2
3C-Standwhip3
4C-Standwhip4
5C-Crouchwhip1
6C-Crouchwhip2
7C-Crouchwhip3
8C-Crouchwhip4
1D-StairUpWhipA-1
2D-StairUpWhipA-2
3D-StairUpWhipA-3
4D-StairUpWhipA-4 //These are with the front foot on the top step, because now there are extra stair animations
5D-StairUpWhipB-1
6D-StairUpWhipB-2
7D-StairUpWhipB-3
8D-StairUpWhipB-4 //These are with the back foot on the top step.
1E-StairDownWhipA-1
2E-StiarDownWhipA-2
3E-StairDownWhipA-3
4E-StairDownWhipA-4 //Same deal as the UpSteps, only now going Down Stairs.
5E-StairDownWhipB-1
6E-StairDownWhipB-2
7E-StairDownWhipB-3
8E-StairDownWhipB-4 //Yaddayaddayadda
1F-JumpWhip1
2F-JumpWhip2
3F-JumpWhip3
4F-JumpWhip4 //For when jumping up/jumping forward before the apex of the jump
5F-ApexWhip1
6F-ApexWhip2
7F-ApexWhip3
8F-ApexWhip4 //For at the apex of the jump. May not be necessary to implement at all but they look cool so I kept them.
1G-DropWhip1
2G-DropWhip2
3G-DropWhip3
4G-DropWhip4 //For when you're falling and attacking, or after the apex of a jump.
5G-Falling2 //Thought I'd implement another falling animation frame so that his outfit is furling in the air as he falls.
6G-ItemCrash-Air-1
7G-ItemCrash-Air-2 //I wanted to keep everything in one square file, so these two frames are both using the same 32x32 space.
8G-ItemCrash-Ground-1
9G-ItemCrash-Ground-2 //If you wanted to implement item crashes on the ground, these are what Leon's would look like.
EDIT:
And just for good measure, here's a NES-tificated Leon's Theme.
Leon's Theme... in NEStificated Form!And here, just for fun, a Curse of Darkness tune, also NES-tificated.
Garibaldi Temple (CoD)... NEStificated.