With Juicebox-Pro, you could certainly produce individual galleries to each display a different Flickr Set.
1. Show all my Flickr sets, in the same order Flickr shows them. Having a thumbnail for each would be required.
With Juicebox-Pro, you could create as many individual galleries as you like but you would need to link them together manually using techniques such as those in the Embedding Multiple Galleries support section. Juicebox-Pro does not come with any automated method of linking together multiple galleries.
An alternative solution would be to use another one of our products: Showkase.
Showkase is a PHP web application which would allow you to create a complete portfolio web site online using a web browser interface.
Showkase has full support for Juicebox-Pro and your Flickr-based galleries could be created within the application itself (or created with JuiceboxBuilder-Pro and then imported into Showkase).
You could create gallery index pages and have as many galleries listed on each index page as you wish.
Each gallery is represented by a thumbnail image with the gallery title displayed below and the gallery is opened when the user clicks on the image.
(Showkase also has the ability to create non-gallery pages such as 'About', 'Contact' and 'Basic' pages where you can enter information about yourself and contact details.)
All of this is done automatically within the interface without the need for any manual coding at all.
If you would like to take a look around the Showkase interface, you can log into the Live Demo Admin here.
Demo sites can be found here and a sample Gallery Index page can be found here.
Showkase can be purchased as Showkase-Standard (which comes with Juicebox-Lite and SimpleViewer-Standard, the free versions) or Showkase-Pro (which comes with Juicebox-Pro and SimpleViewer-Pro). The only difference between Showkase-Standard and Showkase-Pro is the bundled viewers.
2. Once the user selects a set, show the photos in there in chronological order or the order Flickr uses.
Flickr sets are always returned in the order specified on the Flickr set page.
For more details on how to change the order of images in a Flickr Set, please see this FAQ:
How do I change the order of images in a Flickr Photo Set?
3. The list of sets should update automatically as new sets are created.
You would need to add a new Gallery Page within your Showkase site each time you create a new Flickr Set. (There is no way for Juicebox-Pro or Showkase to know that you have created a new Flickr set.) However, this is a quick and easy process which can be done in a matter of minutes (and the new gallery can automatically be listed on a Gallery Index Page if you like).
4. Show the text for each photo, either next to it, or via some sort of popup or mouseover.
Juicebox-Pro supports displaying the Flickr Title and/or Flickr Description in the gallery's caption area.
Please see the Flickr Options section of the Config Options page for details.
The caption area can then be positioned using the captionPosition configuration option.
So I don't need a non-mobile-friendly solution, I already have that.
Both Juicebox-Pro and Showkase are mobile-friendly.
Please try viewing the demo Juicebox galleries and Showkase sites in any mobile devices you have.
Juicebox: http://www.juicebox.net/demos/
Showkase: http://www.showkase.net/demos/
We do not have trial versions of Juicebox-Pro or Showkase but we do offer a money back guarantee:
Juicebox: Can I try a trial version of Juicebox-Pro?
Showkase: Can I try a trial version of Showkase?
I hope you find the information (and links) above helpful.