You may find there are many similarities between American and German culture. There are differences, though. Yes, Germans sometimes drink to get drunk.
In Hamburg, there is a street, the Reeperbahn, or mile of sin. It's sort of like New Orleans on Friday and Saturday nights. You can drink in the streets, see a band, see a sex show or go from club to club. It's pretty packed until almost 4am in summer.
Hamburg is a major port and industrial city in the north. Munich, in the south, has the beer gardens and Alpine feel to it. It's home to BMW, Siemens, the Alps, castles, Oktoberfest,and much more.
They can make fun of themselves, as we do, with differences between the North and South, but it's not serious or common to do so.
The family is similar to the US, but German children are, in my opinion, well educated and independant. Education is very important, and math/science are a big deal. Think German Engineering. I don't know how "free" the university system is, though.
International travel is quite common and easy, considering how many different countries are so close. I believe this opens their minds to many different cultures and languages early, so they can be more "worldly" than many of us here.
Beer is considered a basic food and is not taxed, as it is in the US. A glass or two of beer or wine is normal at dinner. The food is quite good and international. They seem to be more sophisticated than us when it comes to food and dress. fast food is present, but no common. They may not have as many clothes to wear as us, but they do know how to dress well and coordinate their outfits. They wear dress shoes where we wear tennis shoes.
Like the U.S., many Germans are open to others. I have several friends there. Some are not, very open, like here. Their social structure, politically, is more liberal than ours. They pay quite a bit in taxes and petrol (it's benzine not gasoline) is quite high because it is taxed so much.
In many ways, the Germans have more freedom than we do. The autobahn is one example. There are strict speed limits in places, and your car must me well maintained (no rust for example), but you can drive as fast as is safe. My personal best is 280KM/hr. Driving over posted limits is verboten, and you will get a ticket if you exceed the posted limit.
There are also some quirky laws. You cannot name your child anything you'd like, for instance. It must be an approved name in a book.
Homosexuality is no big deal, similar to larger American cities. I have found most Germans to be both more tolerant of others and, paradoxically, some are quite racist. I have found a great dislike of Russians, in some though.
As far as women are concerned, they are very equal to men in the work place and politics. Just look who their leader is, Angela Merkel.
You will have a wonderful time there. The country is beautiful, the people mostly terrific, history is amazing, and their values are quite similar to ours.
Sorry, I don't know anyone in Heidelburg. Have a grand time!