Do any databases allow you to specify that a transaction needs a particular mode, and then that mode is implemented only for that transaction? e.g.,

  START TRANSACTION MODE READ REPEATABLE;

or something like that. It would seem to be a way to only use the extra resources when consistency is paramount. Of course it would take a lot of careful thought to determine which transactions need this mode...