Luxury vinyl plank and ceramic tile get compared as if they were interchangeable. They are both hard-wearing and both handle water, but they behave so differently underfoot and over time that the room usually picks the winner for you.
LVP is warmer, quieter, more forgiving on a dropped glass, and far faster to install across an open floor plan. It floats, so it tolerates a slab that moves seasonally. What it does not tolerate is a subfloor that is not flat: every high spot becomes a wear point and every low spot becomes a hollow click. It also does not love long runs of direct sunlight, and the cheap end of the market has a wear layer thin enough to scuff within a year of dog claws.
Tile is the more permanent answer, and the more demanding one. Done properly, with a rigid substrate or an uncoupling membrane, full mortar coverage under every piece, and real waterproofing in wet areas, a tile floor outlives the kitchen around it. Done improperly, it cracks along a joist line or lets water into a subfloor for two years before anyone notices, and the repair means taking the floor back up.
Room by room, the split is fairly consistent in the houses we work in. Living areas, bedrooms, and hallways go LVP for comfort, quiet, and cost. Bathrooms, mudrooms, laundry rooms, and showers go tile, because those are the rooms where a real waterproofing system matters more than warmth underfoot. Kitchens can go either way, and usually come down to whether you stand at that counter for an hour at a time.
Whichever you choose, spend the money on the preparation rather than the top of the material line. A mid-range plank on a flat, dry, properly prepped subfloor will outperform a premium plank laid over an uncorrected floor every single time.