https://www.cbr.com/star-trek-tng-riker-decision-avoided-franchise-trap/

Commander Riker staying on the Enterprise preserved The Next Generation's ensemble and explains why splitting franchises apart so often backfires.