I am using certain array compound indexes which are quite heavy. I've seen cases where these can slow down the query plan selection on queries where we do not intended to be used. (We call this the "Mongo Index Butterfly Effect".)

It would be very nice to be able to define something like "hint_only: true" on the index itself to prevent it from being used EXCEPT when it has been explicitly hinted.