I just saw this thread and I had to make some recommendations, most, if not all, are somewhat Cloti fanfics but mostly from the point of Cloud:
Anchor -
https://www.fanfiction.net/s/4727698/1/Anchor - I haven't read this one in a while, but I always remember the title. The story left a good impression on it. It takes place 2 years after AC ,is canon to the compilation and the characters are in character in my opinion which is one of my personal favorites when a writer keeps true to that sort of thing. It's well written and provides insights to the characters minds. I highly recommend this fic.
Like Metal in Water -
https://www.fanfiction.net/s/3848831/1/Like-Metal-in-Water - A dark Cloud/Tifa fic, takes place 2 years after DoC, and is about Cloud choosing the mercenary life after things don't work out Tifa. Gory, keeps you on the edge of your seat (at least it did for me lol), keeps true to the characters (IMO) and the mythology of the FFVII compilation. I find it an an interesting take/divergence from the typical happy endings stories and also how Cloud takes a non-typical path of a 'hero'. Very good read. If you like angst, this is one of those. XD
I also recommend after reading Like Metal in Water reading the sequels; one is written from Cloud's point of view 'Beneath the Rust' -
https://www.fanfiction.net/s/12381976/1/Beneath-the-Rust and another sequel that follows alongside the same timeline as Beneath the Rust but is from Denzel's point of view 'At the Water's Edge' -
https://www.fanfiction.net/s/12458785/1/At-the-Water-s-Edge . They very good follow-ups.
Chasing Daylight -
https://www.fanfiction.net/s/4388621/1/Chasing-Daylight - A short fic; Cloud deals with the death of Tifa sometime after AC/DoC I would imagine, it doesn't make too clear where along the timeline this takes place. Angsty at first but hope grows as the story progresses. I thought it was nice fanfic about acceptance with living and dying.
The Only Remedy -
https://www.fanfiction.net/s/11787623/1/The-Only-Remedy - An awesome, short fic focusing on Cloud and Elmyra's relationship (not a romantic relationship) after Aerith/Aeris' death and how she gradually grows to accept Cloud into her life again. Short but sweet fic, definitely a must-read. Follows canon/compilation timeline.
Reduced to Specimens -
https://www.fanfiction.net/s/4257079/1/Reduced-to-Specimens - I'm pretty sure this has been recommended. But just in case it hasn't...Takes place during the time Cloud and Zack where in Nibelheim and also the time between their escape up until Zack makes his last stand before Midgar. I thought it was a pretty interesting take on what happens during the time Cloud and Zack were experimented on, in my opinion it really solidifies why/how Cloud and Zack are so close. In my opinion, while Crisis Core provided a basis for their relationship, this really brings it together. I also enjoy how the writer spares no expense showing how crazy Hojo is, since I also feel this is something that was glossed over in Crisis Core and didn't go into much detail (maybe perhaps due to space limitations or just not wanting to explore that side of Zack's story.)
Anyways, I have other recs but most of them are short stories. Hope y'all enjoy.