I personally like controller rumble. It can be used for so many different things in game, such as indicators or to provide a bit of feedback when performing a task, or even emphasizing effect in cutscenes. In the Yakuza games, if a character is angry and yelling, the controller vibrates non-stop until you move to the next dialogue line which I think is hilarious. Most of the time I don't even notice it and it never bothers me. If I'm not using my controller and using M+KB, I turn off my controller so it doesn't rumble.
I've not tried the PS5's adaptive triggers though, I am really curious how that would feel in game. The idea IIRC is that the trigger buttons will modify how much force it takes to press it down, so things like shooting a gun feel a bit more "realistic" or "immersive" I suppose. It just seems like a very interesting idea that I'd like to try some day, however not many games on PC support the feature, and the ones that do require the controller be plugged in via USB which I don't like doing.