The spools you make do not work well at all. I found out the same as you did. The cardboard Spools work well until they get toward the end, but sometimes they do empty correctly. I like the idea someone had of putting; I think they said, electrical tape to help with the traction.
The other thing I have are about 5 or 6 empty Bambu spools I purchased. I made a spool winder. A Milwaukee M18 Power Tool Battery powers it with a variable power supply and a 1000 rpm motor. I never run it close to 1000 though, I have bearings in each spool holder and an 8mm shaft with an adapter to hold the spool. All I do is choose the speed and it works like a charm and especially with the smaller or odd-sized spools that I could not put in my AMS if I wanted to. It’s fast and solves all the problems that the other spool gimmicks cannot do and more.