As a garden designer people often ask about this...
In my view, nothing is as good as real grass, but the most important thing about a garden is that it is used and is useful. If grass doesn't work in your house then don't try and force it. If having artificial grass (or as a last resort, paving) means that you go outside more, eat together more, use your house for parties more, let your children play in the garden more... then thats a good thing.
If I am using artificial grass, I try and make up for it by having really generous planting - whether in raised beds, borders or pots I try to pack in plants which will provide habitats for wildlife and some nectar for pollinators so that at least the borders are a little more environmentally friendly.
Lastly, there are some fantastic products on the market which do look realistic, but as yet there isn't anything that I think feels realistic. On a hot day its warm underfoot rather than as cooling and fragrant as a real lawn. It does also involve some maintenance - the odd jet wash if the neighbours cat does its business and clearing any fallen leaves off (which on a normal lawn might rot in).
So, if it means you will use your garden more and get closer to the plants and creatures within it, then go for it.