We have two female house cats, very happy, play, run, chase, "hunt" very cuddly and tame. If we are out in the back garden they will come out too, but never roam any further, never try and escape from open doors or windows..etc. very content.
We don't have a huge house, just a terrace on a busy road.
We had a male house cat before that, no problems with him either.
There's positives and negatives to everything and depends on the cat's temperament of course. But with cars, illnesses, so many strays where we live, opportunity for them to be poisoned accidentally...etc we decided to try to have indoor cats, and it was great.
Lots of cat experts actually support having cats indoors and creating safe outdoor environments for them and "catios" Cat's outdoors can be put under a lot of stress, especially if there are a lot of neighbourhood cats.
If you decide not to get a kitten, and adopt, cats protection will help you find an indoor cat, that's where we got out first cat from and we specified we hoped to keep them indoors so they helped us find one that was already and indoor cat.