Hi Niels, and welcome to the forum!
Yes, there are a number of people here on this forum that have experimented extensively with codecs, conversion/transcoding for LightWorks. I have, without contributing a great deal, participated in these discussions and am aware of the outcome.
First, LW accepts files generated in the GoPro Cineform codec. That's the one I would use for GoPro files. It's a free download.
For all other file formats the consensus is for DNxHD and ProRes. DNxHD is the most processor-friendly, but it requires the payment of a licensing fee of $ 65.00. It's worth every penny of it. To convert/transcode AVCHD I recommend a free program called DSLR Post Prep, written by an avid LightWorks user, Mr. Wayne Norton.
LW will ingest all sorts of codecs, provided you buy the PRO license, which is $ 60.00 per annum. It will even swallow AVCHD. Yet, be advised that AVCHD isn't processor-friendly and will show deterioration if you have to export and re-import it several times. So the consensus remains with the codecs above.
I'm amazed at your use of the term "exotic codecs" in regard to AVCHD and GoPro. They are THE industry standard in consumer/prosumer (and some pro) cameras.
I can't predict how you'll make out with LightWorks. It's a wonderful program. But it has definitley a learning curve. And, in some areas, you'll have to re-think! Also, the LW-specific semantics is quite different from their competition. Sometimes I think that they just like to be a bit excentric ....

.
Try it, it's good! J.