Basic premise is Mane 6 end up in the human world and try to adjust while being taken in by main guy.

Main guy and Fluttershy end up falling for eachother over time until they discover a way to send them back, resulting in a tearful goodbye.

I specifically remember the epilogue where the main guy decides to travel abroad with Flutters’ cutie mark tattooed on his arm.