Let us start by hitting the cue ball dead centre, no top spin, no bottom spin and no side spin. The ball starts by sliding along the surface, gradually it will start to rotate because friction slows the bottom of the ball but not the top. The harder the ball is hit, the further it will go before the rotation becomes obvious.
If the ball is hit hard and it is only a short distance before it hits another ball, and lets make that a head on hit, there will be very little rotation of the cue ball and it will look as though it stops dead and the other ball goes of at the same speed that the cue ball was moving. In this instance we can say that all of the energy from the cue was transfered to the cue ball as kinetic energy and intern the cue ball tranfered it as kinetic energy.
If the cue ball is not hit so hard or it travels a bit further before striking the other ball, the cue ball will start to rotate or roll. In this case the initial energy from the cue will be lost as friction, stored in the rotation of the ball and stored as kinetic energy. When the cue ball strikes the target, the kinetic energy is transfered to the target ball but the energy stored in rotation will keep the cue ball rolling until friction converts it to heat.
Now, if you apply spin to the cue ball by hitting it off centre you will change the magnitude and maybe direction of rotation of the ball when it hits the target ball. The kinetic energy will be transfered to the target and the energy stored in the rotation or spin of the cue ball will determine movement of the cue ball after it strikes the target.
Some of the energy stored as rotation in the cue ball will be transfered as rotation to the target ball. There is very little friction between the balls and so this transfere of energy is very small and, unless you hit things very hard, not noticable.
I hope that wihout diagrams and yards of calculations this describes roughly what is going on.