From a hardcore switcher
I hated shooter games until I got to know Borderlands 2, which was my first BL, and I started playing it on PC, at 60 frames per second. In 2015, I bought a PS4 and the Handsome Collection with it (had played all Borderlands games extensively at that point). To be honest, the switch wasn’t too bad as I just had to adjust the sensitivity and toggle the FOV a bit to increase my line of sight. By now I’m probably just as good on my PS4 as I am on PC.
There are however some things that could cause problems: The obvious one is the aim acceleration which some games just don’t have, Borderlands The Pre-Sequel being one of them as it is bugged to this day on consoles (on the PS4 at least, don’t know about the XBox). The second thing is that it takes a bit of time until you get used to the feeling of aiming with an analog stick, but that will probably not be too bad.
In general, Borderlands games control pretty good on consoles, but you need to be aware that the ever so slight delay a controller will have can be noticeable at first, but is no dealbreaker in a PvE game like Borderlands and you will get used to it eventually. I still would advise you to just try it out. Ask a friend to lend you any FPS or just for the Handsome Collection and see for yourself.