The thing nobody tells you about sterling silver is that it tarnishes, and it will do it fastest in the exact drawer you think is safest, dark and shut away from everything. Mine went a dull grey in about six weeks sat in a jewellery box doing absolutely nothing. It's still worth having. The weight of it, the way it catches light without trying, the fact it doesn't go that cheap brassy colour after two showers, that's a different league from most things at the same sort of price.
Where it falls short is anywhere you're not prepared to take it off. Swimming, washing up, the gym, any of that, and it either dulls quicker or gets a knock it didn't need. I wore one through a full day of moving house and came home with a scratch I still notice. If you want something you genuinely never think about, plain stainless steel is the honest answer, and I'll say that even though silver looks nicer on.
How it ages depends entirely on whether you wipe it occasionally with a soft cloth or let it sit. Mine that gets worn most, with jeans and a plain jumper, stays brighter than the one I keep for better days, which sounds backwards but isn't, movement and skin oils actually keep it polished in a way that storage doesn't. A quick clean after it's gone cloudy brings it straight back, no special trip required, just a cloth and a bit of patience. Damp is the real enemy, so off it comes before a shower, not after you notice the white marks.
On finish, plain polished silver is the easiest thing to put with everything else you own, it goes under a shirt cuff or over a jumper sleeve without any thought. Anything with a matte or brushed finish hides the odd scratch better, which suits anyone who isn't going to baby it. I'd be careful with anything very delicate and chain like if you've got a job with your hands in and out of bags and pockets all day, mine gets caught on a coat zip more than I'd like to admit.
I've got one with a slightly heavier link that goes with literally every top I own, plain tee, big coat, the lot, and one dainty version I save for days I'm not carrying anything heavier than a handbag. Both earn their place differently. Before you buy, it's worth asking yourself honestly whether you'll take it off for the shower and the gym, because that single habit decides whether it still looks good in a year or just looks tired.
Another good place to look is silver bracelets.