Well to finalise the thread, I bought the addin card as recommended but had teething problems trying to connect it to my eGPU.
After much research, I found that rated cabling is a thing and after connecting a rated thunderbolt 4 cable to the new USB addin card I started troubleshooting.
A few BIOS tweaks and updates here and there and everything is now connected and working. New eGPU is being picked up by Thunderbolt Control Center
Thank you to anyone that stopped and read the thread especially to the tech resources that stopped to post and help.
It was of massive help being able to reach out to the community as always. I just hope I haven't wasted too much of the community time trying to diagnose the problem.
Thanks for your help again. 😊
Kind regards