This city in the heart of the Frankenjura is a big tourist attraction, as well as a climbing haven. If you're on vacation here in the Frankenjura, you could easily just come to Gößweinstein for your entire trip and still manage to get a great feel for the culture, food, beer, and area. Additionally, since it's possibly the biggest city that's actually within Frankenjura, you can enjoy some other kinds of food if you get tired of the German fare. Also, there is a Lidl and a Rewe if you need to do any grocery shopping. As for overnight possibilities, you can sleep in the parking lot near the Stadelhofener Wände for free, or pay to camp in Moritz, or stay in one of the Pensions in Gößweinstein (look for a Zimmer Frei sign).
As a rather large town/small city, it is easily found in the center of the Frankenjura and therefore reached from any direction.