Cats prevent house mice (and rats) but they do bring in mice (usually dead) and birds (often alive) ime. One quickly develops the skill to cover with two sheets of kitchen roll and deftly scoop up in the dustpan, holding in situ with the brush en-route to the dustbin.
They will scratch your furniture and carpet.
They may love you as loyally as a dog. They may not.
They may wee in your house when stressed or unwell.
The costs stack up. My two rescues currently cost £38pcm for insurance. My old boy's insurance had gone up to £89 pcm, £135 excess and then covered 80%.
Fleaing, worming and vacs I pay ,£13pcm through the vet.
Food is about £120pcm (OK I accept They have the good stuff).
One of my vet nurses looks after them when we are away £15 per day for two.
If they are indoor cats there is the bind of litter and trays and additional cleaning.
They are expensive, cause damage, and are a tie. On the other hand I don't think a house is a home without a cat.
You have to be a cat person to commit to a cat. No cat will commit 100% to you.