I would stay away from Mogami, unless you're doing a short (10 feet) run or less before your first buffer, or simply like a lot of high end roll off. I used Mogami for years because that what was "the standard". Then I decided to read up on cables, try some different brands and constructions and see what's what. Long story short. Stay away from the far extremes of capacitance. Mogami 2524 is 40pf/ft and considered a high capacitance cable, meaning the highs are quite subdued and rolled off. On the other end of the spectrum there are cables like Sommer The Spirit LLX that's 16pf/ft. It's quite squeaky to my ears. a lot plink and annoying noises because it lets through high end treble that's not flattering to a guitar tone. It makes you guitar sound more DI in a way.
NOW, that said. The thing that matters in terms of tone, is the total capacitance before your amp or first buffer. So it will vary greatly depending on how long your cables are. Running a super long cable before your pedalboard or amp? Then a low capacitance cable might be beneficial. Sitting in a wheel chair on stage? Then a high capacitance short cable might work. What cable you chose depends on your taste, pickups, and cable length. I use 20 feet of cable before a Suhr buffer, and like about 500-550 pf of capacitance before my signal hits the buffer. So I use Cordial The Road 75, which sits in the middle of the capacitance spectrum at 27pf/ft.
The total capacitance is really all that matters in terms of the tone. But, better constructed cables offer other advantages, such as better shielding, resistance to general cable noise when you move around, and longevity. In this regard, Mogami falls short. It's a very old cable design with some shortcomings. Even if you want a high capacitance cable, I would still suggest tlooking at other brands that offer better construction (like braided shielding, OFC class 6 copper instead of standard copper, or skin/gas/skin insulation instead of standard PE insulation).