I assume you mean the one by Mark Mackinnon aka Shadow Chronicles:
RANMA-MULTI 'On A Clear Day You Can See Forever' by M MacKinnon - [Dld Date=09/07/2008] - [Dld Size=4865kb] - [Dld File Cnt=22] - [Dld Status=Inactive]
As a FYI, he has several large draft versions of that story on the site, at least one of which has him meeting Pirotessa, not sailor moon.
As for crossovers that are more unusual, there are tons of them, how about for ones to come immediately to mind...
One where Chibi Usa and Saturn wish for a consort to share and Ranma appears with a Youma, he kills the youma, passes out, then they drag his unconscious body to bed. And other yjinks, like Mamoru destroying Saturns bedroom and attacking Uranus to get at Ranma.
RANMA-SM 'A New Home' by Innortal - [Dld Date=03/18/2006] - [Dld Size=163kb] - [Dld File Cnt=7] - [Dld Status=Inactive]
One where Sailor Pluto from the future removed her past self powers, sends herself into exile as a vacation, and she ends up rooming with a college age piano playing Ranma, I like the cockroach scene.
RANMA-SM 'Timed Vacation' by ukie1 - [Dld Date=10/03/2003] - [Dld Size=256kb] - [Dld File Cnt=7] - [Dld Status=Inactive]
- - [MD Source=FF.NET] - [MD Rating=T] - [MD Word Cnt=46126]
- - [MD Summary= Ranma Sailor Moon Xover. Actually it's a story about a cat a flock of doves a cockroach a piano a piano-playing Ranma and a Setsuna who's not Sailor Pluto anymore but still can't stand cockroaches.]
- - [Direct URL] https://www.fanfiction.net/s/1321139/1/
- - [Author1 URL] https://www.fanfiction.net/u/135095/
How about Dark King Acending, where Ranma is classed as sailor pluto's hidden ace in a war, and she subtly guides him into his morals. But messes up and gets emotionally attached to him...
RANMA-SM 'Dark King Ascending' by SoftRogue - [Dld Date=02/02/2003] - [Dld Size=102kb] - [Dld File Cnt=3] - [Dld Status=Inactive]
Both humorous and horrifying, and sadly dead, as I believe the author wrote himself into a corner... A series of sailor Venus and Ranma encounters that go so right and so wrong that Ranma believes them best friends, and she believes them worst enemies...
RANMA-SM 'Hell Hath No Fury' by Bob Lobster - [Dld Date=01/07/2003] - [Dld Size=189kb] - [Dld File Cnt=3] - [Dld Status=Inactive]
A Setsuna so put out by Haruka and Michiru's bedroom antics, she arranges a companion for herself... in the form of a Ranma Saotome... But she cannot go about it in a normal straight forward way.
RANMA-SM 'Setsuna's Revenge' by Lerris - [Dld Date=07/18/2006] - [Dld Size=85kb] - [Dld File Cnt=2] - [Dld Status=Complete]
A Ranma trains Senshi, where Ranma knows magic, where the inners worship Kasumi, where Haruka is a closet Ranma fan, where Nabiki takes on a magical pirate, and Shampoo has a generational rival.
RANMA-SM 'Butterflies and Wild Horses' by Smylingsnake - [Dld Date=05/08/2010] - [Dld Size=406kb] - [Dld File Cnt=13] - [Dld Status=Inactive]
Where Ranma is a time displaced mage and can no longer be a martial artist alone, where Chibi usa ends up tracking him down, only to befriend ranko, and a pokemon fan with amagical artifact ruins her disguise in front of ranma and shreds her cloths... and they end up saving the future and the past, and giving both Pluto's headaches.
RANMA-SM 'Ranma, Mage of the Darkness' by HistorianoftheKais - [Dld Date=12/07/2008] - [Dld Size=380kb] - [Dld File Cnt=14] - [Dld Status=Inactive]
Can't forget the following, involving Ranma discovering whom actually was behind everything bad in his life, and starting a prank war to end all prank wars...
RANMA-SM 'The Best of Times' by Ozzallos - [Dld Date=02/25/2006] - [Dld Size=585kb] - [Dld File Cnt=11] - [Dld Status=Complete]
Ami, as a evil dungeon keeper, and a lot of her especially early acts being misinterpreted by the world she finds herself in, making her out to be a pervert as well as a world conquerer.
SM-AA 'Dungeon Keeper Ami' by Multiple - [Dld Date=12/22/2015] - [Dld Size=5203kb] - [Dld File Cnt=202] - [Dld Status=In Progress]
EDIT: Almost forgot... The Sailor mercury from the Frozen thing... was that:
SM 'Life's Blood' by Dro'gan NiteFlier - [Dld Date=08/28/2004] - [Dld Size=314kb] - [Dld File Cnt=9] - [Dld Status=Complete]
I quite liked it, but I'm afraid I did not really consider that humorous... One of the best Mercury as a magical assassin story I've seen... a tiny bit disappointed at the end though, I do not thing she should have taken the vow but remained separate.