There are different types, three main types, but many different versions.
Square taper 'cartridge' BB's are usually for older chainsets, or lower end chainsets - my bikes are old so 3 run on cartridge BB's.
You've then got external cups, mainly SRAM GXP & DUB and Shimano Hollowtech II - these are the better options of the newer BB's - easy to service, and cheap to replace. Shimano better than SRAM (I have a SRAM GXP).
Then press fit where the bearing is pressed into the frame - pro's and cons but can lead to creaks if not fitted properly, and potential for frame wear. Many manufacturers going back to external BB's.
Personally, if you've got a modern bike, or are planning to, external cups are better for longevity/less problems.