A lot depends on the distance you're willing to drive, the length of your stay, the time of year and how much riding you like to do in a day. Concentrations of good quality trails near a single hotel or campground are hard to find. I've been travelling all over the eastern US in search of places like this and have found precious few.
If you plan to stay a week or more in the same location, and want to ride a variety of nice trails, I'm afraid you will be hard pressed to find an ideal location. This is especially true if you seek a warm weather climate. Some of the more enjoyable trails however, are worth riding several times during the same stay. Long length trails are also attractive since you can choose a hotel or camp mid way on the trail and ride in two directions. I frequently do this and sometimes change hotel locations 2 or 3 times on a 7-10 day trip.
I've ridden several of the trails mentioned in your link and all are indeed worth a trip, albeit a short one. It should be noted that some however involve riding on public roads with vehicle traffic. To me anyway, that negates a lot of the scenic pleasure since you need to be cautious of vehicles around you.
The best approach I've found is to take frequent 4 to 5 day trips instead of longer ones and ride 3 or 4 nice trails while staying in a single location. Also, don't discount trails that aren't paved. Many of the best trails I've found have well maintained packed gravel surfaces. I posted this list of my favorite trails a few years ago and many can be combined into a single trip. Depending on conditions, most are rideable April thru November. Unfortunately for you, they are mostly in the eastern US:
Edit 6/15/20: Added #49 & #50. Edit 12/16/19: Added #47 & #48. Edit 6/23/20: Added #51 & #52. Edit 8/17/20: Added #53 Edit 10/24/21 Added #54 Edit 2/3/ 23: Added #55, #56 Now that the 2019 biking season is pretty much over here in the northeast, I decided to compile a list of my favorite bike...
For example, I frequently combine #1, #2, #4 and #20 in a 5 day trip to Cumberland MD. I can recommend others if you're ever out this way.
Good luck in your quest and please post what you find!