Need a recommendation

Play Warframe!

Just kidding, I did read what you wrote. I don't have experience with any of those paid looter shooters, but if I had the money and wanted to pay for such a game, I would personally go with Destiny 2. For what it's worth :)

Dont know if its exactly the same. But Borderlands 2 is fun.

i don't think they is best for sure more people not like it but for my personal taste i like Deus Ex,dishonored,Prey,Bioshock,Condemned,Thief,Dark Messiah Might and Magic etc.

The Division 2 looks like a great looter shooter, altough I've only played the first one. It's more a "shoot-from-cover"-shooter than for instance Warframe (Similar gameplay to XCOM(?) and Mass Effect)

The Division 2 has fixed the numerous flaws the first one had, has an impressive amount of content and is being supported with free post endgame stuff. Plus there's no shortage of players playing at every difficulty level, unlike Anthem. I've enjoyed it quite a lot so far and i'm looking forward the next patches. Between Destiny and Anthem, The Division 2 is the best of the bunch.

All are better as Warframe.

I would advice to pick a not so expensive one from them.

from my experience i would recommand destiny 2 but since the f2p version is out in a month and a half i recommand waiting for that unless you can get a key with a heavy discount . haven't tried the division 2 outside the beta which felt more of a division 1.5 with some issues so i skipped it and would not recommand getting anthem atm for sure i only enjoyed it for like 2 hours

Personally I found Borderlands to be dull, bu it's generally what you are looking for.

I'd highly recommend The Division 1 especially if you like cover-based combat (you'll die a lot if you don't take cover)+playing in third-person, and Destiny 2 if you love playing in the first-person view. Note the difference in the setting as well.

I'd also say The Division is more single-player friendly than Destiny 2 mainly because the latter contains public events where you may need other players' help to complete. If you do play Destiny 2, you should definitely try the public events though - aside from the much better loot you might get, these events are pretty fun for the first few times, especially if you get a few players who know what they are doing, but it can get a tad bit repetitive after :) I didn't try the PvP aspects of both games though so I can't comment on that.

I've noticed you played Borderlands 2 for quite a bit, and if you liked it, I think you might prefer Destiny 2. Both games have some similarities and I've always liked to describe Destiny 2 as a unique combination of Borderlands (the gun play and game genre) and Halo (the setting, atmosphere, and general feel - it's from Bungie after all :) ).

I'd recommend Wildlands too but it isn't a looter shooter.

what is exactly a looter shooter because you mention online games while you don't want online games?

Literally, in all sci-fi RPG, you can "shoot' and involve a lot of looting so from that perspective every modern fallout game, Elex, etc, belong to this category.