Fable 2 (or 3?. I think 2)

The second player doesn't get their own full character/hero but more like a henchman, who can't progress or get better. And they are forced to stay with the main player.

They do get to run around in the same room and attack enemies and stuff, but they are pretty weak and can really only support their main player.