Nothing is absolute. There are plenty of 2.5T owners (CX-9, CX-5, CX-30, Mazda6, Mazda3) who have not had any issues with their engine. Plenty of newer 2.5NA owners with no CD issues. This isn't to say that these issues should be ignored, it's just to say that the reports on this forum represent a small sample of actual owners.
A TSB is available for the 2.5T engine coolant issue, and a TSB also exists for the potential engine oil consumption issue in the 21+ models. A TSB for the CD issue was issued a couple of years ago. While these issues can be a potential concern, Mazda has acknowledged them, which means getting support for these issues in the future should be easier. There are some other well-known brands with issues that were/are just as bad, if not worse, than what we see on our forums, but those manufacturers have a history of burying their heads in the sand. Everything has issues if you dig deep enough.
IMO. If you choose to go with the CX-5, the 2022 should be a pretty safe bet. There are much worse problems than having to top up your engine oil once in a while (if you have an oil consumption issue). Mazda's cars aren't perfect, nor do they hold the title of "most reliable". They do tend to rank very high in reliability, right up there with Toyota and Lexus. Their interiors receive a lot of praise, same goes for handling/driving experience (but that's kind of a given with Mazda). My $0.02.