I used it, and I would disagree that it was "complex" to use. No more than non-transacted Win32 file APIs anyway.
We did a nice P/Invoke wrapper around native Win32 functions in C#, exposing FileStream and such, that the rest of the code could then easily consume.
I think the main complexity is that there are no "official" high-level wrappers the way there are for non-transacted APIs. But at the level of Win32, there is no significant difference.
[1] https://en.wikipedia.org/wiki/Transactional_NTFS