I personally don't think your endeavour should be confined, however largely, to a particular locale. Have you looked at my database? You can get a comprehensive list of fish to consider from there and do some homework to see which fish can fit your climate and your water. Once you have that list, you can see which ones you can house, which ones you can house together with other fish you want, and which ones you can source and afford. That will narrow it down greatly, to the point perhaps where you won't need to ask (many) questions.
I believe a bumblebee grouper will need brackish later in life, just from reading a little bit, no experience.