One question per page, answered in the first sentence. On coding, reach, DAC and AOC, BiDi and connectors. For the full story, we link to the blog.
Within the same rack, a DAC: copper, passive up to about 5 m, cheap and low-power. Up to a few racks away, an AOC (up to 10 m in our range). Longer, through a patch panel, or when you want to replace cable and optic separately: two transceivers with a fiber patch cord.
Yes, if the transceiver is coded for that vendor: the switch then reads it as its own optic and the port comes up as normal. We code every module for your platform before it ships, at no extra cost.
It fits, because SFP, SFP+ and SFP28 share the same housing, but an SFP+ port won't do 25G. Whether the module falls back to 10G depends on module and switch; for an SFP+ port, just buy an SFP+.
Passive up to about 5 m: IEEE specifies passive links up to 5 m for 100G and 7 m for 40G, and at 25G up to 3 m without and 5 m with RS-FEC. Active copper cables go to 7 or 10 m. Need more? Use an AOC or two transceivers with fiber.
On single-mode, look at the colour of the connector or adapter: blue is UPC (flat polish), green is APC (8-degree angle). Each end of your patch cord must match the port it goes into; never connect UPC to APC.
A BiDi transceiver transmits and receives over a single fiber, on two different wavelengths. The U module transmits on the wavelength the D module receives and vice versa, so you always need one U and one D: two identical modules won't give you link.
It's the reach class of an optic: SR is multimode at 850 nm up to 300 m (OM3) or 400 m (OM4), LR is single-mode at 1310 nm up to 10 km, ER single-mode at 1550 nm up to 40 km and ZR single-mode at 1550 nm up to about 80 km.
A 10GBASE-SR SFP+ (850 nm, LC duplex): it reaches 300 m over OM3 and 400 m over OM4. On older OM1 or OM2 fiber you get much less, and LR or other single-mode optics don't belong on multimode.