I'm sure the answer varies widely, however is there a somewhat of a general consensus?
Did men respect the Wehrmacht and ss soldiers? Did women swoon over them? or was it general detestment and disgust?
In all countries Nazi Germany occupied or were within their sphere of influence, they were universally hated. An example that set the tone was the invasion of Poland.
Poland's invasion caused a wave of indiscriminate killings, rape and looting. Operation Tannenberg, the targeting of Polish intelligentsia by the SS and SD cost 20,000 lives alone; but more random and sporadic killings by the Wehrmacht and SS killed anywhere between 16-27,000 people. Overall, 150,000–200,000 Polish civilians were killed in the invasion of Poland. One of the reasons for this is that most of the perpetrators of the violence were of the 18-25 year old bracket; their generation had been raised in a state that portrayed the Poles as the enemy, little better than the Jew. The poverty many soldiers saw in Poland seemed to re-assert this fact in their mind.
Whilst many commanders turned a blind eye, a few were appalled by the scale of the wanton slaughter. Johannes Albrecht Blaskowitz, commander of 8th army, complained on numerous occasions to army high command abut what was going on in Poland and what the SS were doing, he was stonewalled, reprimanded and eventually incurred Hitler's wrath and was removed from command. It's worth noting Blaskowitz never received a field marshal's promotion like so many of his peers; from that point on many looked on Blaskowtiz's dismissal as a reason to never question or complain about what the SS was doing or even what their own men were doing in the countries they were invading.
The invasion of Western Europe was not as vicious (They had the privilege of being viewed as more "civilized" in the eyes of the Reich). Whilst war crimes and civilians being targeted was commonplace, due to the speed many of the countries surrendered (not a jibe;this move undoubtedly saved lives, which the governments were aware of) at they were spared a certain amount of the fate that befell Poland, and many lives were spared. For example, Paris did not meet the same fate as Warsaw, which was all but obliterated. Nevertheless, SD and Gestapo agents made life tough for the occupied populaces, and with British support resistance movements flourished. Whilst most German soldiers behaved themselves whilst stationed in these countries, they were still hated for being what they were, which was invaders.
I could go still further and go into the atrocities and the numerous partisan movements Soviet Russia, but I think the message is clear. Whilst collaborators did exist in every occupied country for various reasons (ideological, personal or even just survival), The Third Reich and it's various instruments were generally hated by the people it occupied.
(Sources; The Third Reich at War by Richard.J.Evans)
Beyond the German's penchant for casual brutality (more pronounced in the East) and collective reprisals, German military occupation financially was highly exploitative. The Third Reich feared so many young men under arms would create inflation of the Reichsmark, so German troops occupying foreign countries were paid in the currency of that state. So Germans in France were paid in Francs, the General Government zloty, etc. The occupation authorities often pegged the conversion of RM to occupation money at artificially high levels, so a German landser stationed in France arguably received more pay than his equivalent in the Reich. German soldiers naturally went on spending sprees and shipped much of these foreign goods home. This fiscal policy, which obviously and intentionally favored Germans, contributed to the overall destruction of occupied Europe's domestic economies. When coupled with the massive expropriations of food and raw materials back to the Reich, this created a larger feeling of desperation in which dealing with German soldiers and other members of the occupation apparatus was a means to survive.
In this new occupation economy, women were often quite vulnerable. Many households lost their main breadwinner through either being a PoW or drafted into forced labor in the Reich to alleviate Germany's labor shortages. Often one of the few economic outlets available for women was to work for the German occupation forces in positions like cooks, laundresses, or other such typically female work. Some women engaged in what became known as "horizontal collaboration," and took on German lovers. Between 1940 and 1943, German soldiers fathered some 70000 illegitimate children in France alone. While the motives for these sexual liaisons would naturally vary from person to person, the German occupation created enough economic uncertainty for women that taking a German lover could alleviate some of the overall hardship.
The postwar political order was not kind to these women and frequently cast sexual relations between occupier and occupied in the most sinister light. Instead of hewing to a victim/victimizer dynamic, both male and female parties were judged guilty in the court of public opinion. German men were portrayed as both predatory and depraved and the image of a Nazi soldier as a sexual sadist became a common trope in postwar European culture. One of the first things usually that happened after liberation was that female sexual collaborators were publicly humiliated by mob justice. The justification for this violence was usually that these women were both mercenary and traitors who too easily gave their virtue to an enemy. This collaboration became a social black mark for these women postwar. Women that volunteered to work for Germany were often more vigorously investigated by the police than their male counterparts and the social stigma of an association with the German military occupation became very difficult to expunge.