I've also never played a Dragon Age but was wondering if I should before the new one and if so, which one!

Inquisition will probably be the best to play. Most of them are stories unto themselves but Veilguard does have some main folks directly from Inquisition 👍