^
Good options and advice (I'm not familiar with the Rode 'guns though so I can't really comment there, but I've heard positive reports from other users FWIW).
Of those options I'd lean towards a pair of Mk41 in one form or another as I feel you'll get the most flexibility out of a pair of quality super/hypers. As Archival notes, the selection is more limited and price-of-entry higher for a really good sounding SD hyper than for other patterns, yet the high directivity which makes it a problem solver in questionable acoustic environments also in my experience makes it one of the most useful patterns for multiple microphone configurations. IMHO, the Microtech Gefell M21 hypercardioid capsule (M210 with amplifier body) is on-par with the Schoeps Mk41, but unfortunately Sweetwater doesn't carry MG. As another potential super/hypercard option, I'm pretty sure Sweetwater carries DPA. You might look into the DPA 4017, which I've not heard or used but has the potential to be of similar quality to MK41 / M21. It's only been available for a few years, so not many around here have used them. All those options are pricey though.
I'd love to try a Schopes CMIT5U , or a DPA 4018 as a single forward facing center mic in my multi-microphone arrays (where I currently use an MG M210 or DPA miniature 4098H), yet I also use my super/hypers in lots of other applications where I wouldn't use an interference tube (shotgun) mic. Also, although an appropriately designed multi-microphone array can cover some of the faults of less than stellar super/hypercards which become more obvious when used alone as a straight stereo pair (bass extension primarily, off-axis smoothness secondarily), there is a quality threshold which still needs to be exceeded, and when used as a simple stereo pair alone there is no substitute for quality hiding the shortcomings. So some less costly hypers can work in multi-mic arrays without major sonic handicaps yet aren't as good as a simple stereo pair, where a top quality pair will work everywhere.