I especially like the Agfa but I am not sure I understand the Minolta zoom, always very complicated to operate the zoom AND focus manually.
I am not big at using adapted lenses ( but I have a few) but if and when I do I tend to stick to what these days are being called “ primes”.
The 40mm Hexanon was one of the first pancakes of when I was young. I don’t really think that there is much intrinsic value to a pancake but they are on fashion.
The Tamron SP 90mm macro was always a lens that I loved, great shape, size and performance.
As for your future lenses, do no discard the 50-230mm without having tried it, read this. Good luck!