I can't judge too hard since I am more of a COD guy than a Battlefield guy, but hearing people say "Well, I might as well buy BF1 or BFV!" is like saying that you will buy Vanguard or MW6(also known as III or 2023) because you feel nostalgic for when the franchise was "good". I dunno, at this point I would just give 2 a shot at best since that's when the franchise was actually good and it has mods. Maybe 3 was also good, I can't say I am familiar with the game as much but I have recently been looking footage of it over and it doesn't impress me. Feels more like nostalgia to me, "you had to be there to understand" kind of thing, and well, I just wasn't there. I do own it on the 360 tho(being given away for free years ago) so I might give it a shot. I think this is the peak of the franchise, there might have been good games before that point, but this was also the last time Battlefield was a serious competitor to COD.
BF1 and BFV tho? Yeah, that's just stockholm syndrome talking, I don't care that these are the most active entries. Halo 5 and Halo Infinite are also more active than fan-run servers for Halo 2 or 3 but I doubt any Halo fan will tell you they're superior or even worth the money. If I had a gun held to my head, I would unironically play 2042 over these two since at least there was some experimentation done with 2042 that you don't see in BF1 or BFV, BF1 specifically I think is vastly overrated and only has the reputation it does because so many people were tired of COD when it came out(kind of like with BF6, history repeats I guess).