E: Lightroom is incomplete in terms of format support

Lightroom is incomplete in terms of format support and probably always will be. Adobe Bridge is better in some ways- you can see Illustrator, InDesign, Premiere files etc but format support will always be incomplete there as well, simply because with video especially there will always be new codecs and formats.