MicroSD and SDHC cards should be able to sustain 50 MHz wire speeds, and 25 MBps ceiling that would provide for.
It's mostly going to come down the ability to absorb the data, and manage the >128KB erase block sizes.
FATFS isn't going to write blocks >32KB, and not going to preallocate. Beyond the transfer modes, there's likely commands/methods in the specs to optimize streaming throughput. Can't say I've looked at that, nor is it implemented anywhere in ST's stacks. The eMMC from certain vendor scan take a block count/length on write that make a significant difference. Seen 27 MBps Writes on 50 MHz 8-bit DDR (104 MBps capable mode), so the bottlenecking is not the availability of data to write.
The cards you use are going to be the easiest thing to change / optimize.
The make, model and specific part# will be important.
The H7-EVAL boards have transceivers if you want to experiment with the lower voltage / exotic modes, but the clocking speed of the SDMMC, and pin speeds are likely to fit the limits before the protocols of the cards.
Some of the H7-DISCO have eMMC part, but they are not fast parts. Pity they didn't use high density sockets like ODROID, et al so some Kingston or SanDisk/WesternDigitial could be benchmarked.
To get high speeds you're going to have to be very selective on parts and wiring.