Okay, so I ran this as suggested in the first post (maximum strength with all BSAs) and although I didn't do any thorough testing (mainly because I don't know how exactly to go about it) I did take a few notes, although probably not of much use, I figured I'd post them anyway.
The file size of my Skyrim directory went down by about 400mb. From 27.2gb to 26.8gb. I'm not sure how significant this is, as as I mentioned before I haven't used DDSopt so I have nothing to compare it too.
Performance wise I did notice an improvement. Although I'm not sure of the FPS impact (in which I may have gained a few frames, but I'm no good with averages and the like) it did definitely seem to be less choppy. I'm no tech expert, but I think I heard somewhere that a VRAM bottleneck may not necessarily be reflected in an FPS counter. But I may be remembering wrong.
So as I said, probably not the best report. Due to my lack of a comparison and my general lack of technical knowledge, but hopefully it's useful to someone. I might do a test with DDSopt tomorrow if I have time so I have something to compare it too as, obviously, the results will vary depending on individual setups.