I struggled some 2 months to troubleshoot and find a working solution
I hope I'll take no more then that to get this done. It seems my problem is not with the CF card or IDE -> CF adapter, but rather with the SCSI -> IDE card. Thanks to MozzerFan I found a good thread on Amiga English Board and I am getting some help from the dealer I bought it from

If I manage to make this work I'll definitely write a how-to because I think it is really needed.
Regarding the CF card, MozzerFan said that the SanDisk 2GB Ultra II gives some problems but the Blue SanDisk don't; so if I where going to buy a new one I would choose the latter.