I've played for 468 hours on PS5 so far, and've only had marginal camera issues. Not sure what you're seeing, but I've seen all of my spells hit enemies throughout my 8 full playthroughs.