As others have said, it depends on your cats personality.
We had to leave my kitty, Honey, with my parents for awhile while we settled in with our move. They already have three other cats. My cat is very mellow most of the time. Of their three cats, Sneaker is also very mellow, so when they see each other, they usually just sniff noses and move on. Mama loves people but hates other cats, so whenever one comes near, she just growls. She spends much of her time on laps or in quiet corners.
The third cat is Spike. He is quirky, but often a pain. He likes to chase Mama. He takes a bite of his food out of the bowl with his paw first, eats it, and then eats the rest like a regular cat. He is terrified of new people, but will warm up after awhile...once he warms up, he's head-butting you!
When Honey came, Spike tried chasing her a bit, but she quickly put and end to that. She chased him back! So now Spike seems to be scared of her and keeps his distance. But they don't fight, thank goodness.
Okay, off topic a bit! Sorry. I'd try for a mellow adult cat, if you can find one! Good luck!