All opiates will make you sleepy. Both of those meds have codeine; one just has Acetaminophen added. Here are some commonly prescribed opiates, in order from strongest to weakest: IV Morphine > Hydromorphone > oxymorphone > oxycontin > hydrocodone > tramadol/codeine.
I pulled a rotator cuff last year and codeine was not enough. I had to go with hydrocodone.