I would love to get some specimens of Scaphirhynchus platorynchus, they are bred in captivity, still fished for in the wild, stay relatively small in aquariums (24 to 30 inches) and do well in warm water. They also do well in koi ponds or farm ponds!
Then we have really dwarf sturgeons...