I am the proud owner of C5 MK2 Exclusive 2.0 HDi from 2006. Have it since 2016 (its my second C5) and for almost 2 years it has some electronic issues - mostly "Power Steering Faulty". From time to time my mechanic is resetting all errors but they come up again. They quoted me crazy money to diagnose but I am not convinced it could help - they are trustworthy but they could always miss something. I am thinking about learning how to do this stuff myself - buy Lexia, ask a million questions here, but at the same time, I have the relatively good budget (12k) I could spend on something more reliable, like Honda CRV. Although I really like my C5 - its super reliable - I had an episode for 2 weeks in 2017 where car was shutting down, but it passed away. I drive around 10-12 k miles every year. Except for emotional attachment (I am one of those weirdos) I think it's good for the environment to keep the car (however new ULEZ rules say differently) - and I can be wrong here. I believe the engine despite 130k miles is in good condition, not sure about the gearbox - oil was never changed I believe (it's automatic).
PS. It's a shame that C5 is discontinued