https://screenrant.com/star-trek-tng-riker-promotion-turned-down/

Riker was attached to the Enterprise and couldn't sever his connection until the USS Titan, here's every ship that he was offered and why he said no.