database indexes: when do they actually hurt performance

indexes are usually good for reading stuff faster right, but some queries have been getting slower lately even after I added more indexes. it feels like the database is spending way too much time just keeping them updated when I write data. anyone have real world advice on when indexes actually start to slow things down, or particular times youve seen them cause more problems than they solve? im wondering about ways to spot this and fix it