Around the Sutherland Shire in Sydney cyclists have been on the roads forever and I think I can say generally the acceptance (and even respect - which goes both ways) is pretty good today. I am 66 and I can recall as a kid of 5 going on picnics around the RNP and further south like the Burgh and Stanwell Park and seeing cyclists even then (in small and large groups). I recall the helmet precursors that looked something like the padded head gear some kids wore in Rugby and League.
Talk about respect; it goes both ways. You don't go sitting right out in the middle of the road holding up traffic when there is more than enough room to move to the left a bit and let the traffic pass.
There was a rider around here recently, he wasn't quite right in the head, he would deliberately sit out in the middle of the road, especially going uphill where he was at his slowest. I saw him even move over the centre line to stop cars from overtaking him. He did that to me on one occasion when I was driving. Another time when I was riding past he wanted to be my brother

Encounters were littering the community facebook page. Anyone that rightly used the horn on him got a verbal spray about how they were racist, as he was indigenous (at least partly).
I don't see him any more riding around, I expect those tactics eventually got him either run over or arrested and his bike confiscated. Obviously, that kind of thing is a rarity, but as a road cyclist you really need to develop a good "road sense" for your own self preservation. That's why I always recommend anyone wanting ride on the road join their local cycling club. Every club has a bunch of organised rides and they have been refined over the years with local knowledge of traffic conditions, peak times to avoid and the quieter bits of road to use. This communal knowledge will help accelerate the development of good road sense.
I see newbies riding in places they just shouldn't be and doing stupid things, like for example, at some sets of light there are 2 right turning lanes, and they are are sitting in the rightmost one. As soon as they do the turn they are going to want to move over to the left. It's stupid and is going to piss motorists off, and might even get them a Darwin award. The point is for a while there before Covid, cycling was the new golf, and the roads were being filled with gumbies that got the frothers hating cyclists and of course the media would pick that up do the story - you only had to look at the online comments from motorists (what moderation?).
Most of that is just noise and not reality. Don't get me wrong, the road is a dangerous place and the sentence for stupidity can be death - the really unfortunate part, it's not alway's the cyclist's stupidity. There are a lot of incompetent drivers out there too and the vast majority of cycling fatalities and severe injuries are just accidents. It sounds counter intuitive but the best you can hope for is a rev head trying to give you a scare, they predominantly know what they are doing with a vehicle and they won't hit you. They have that precise situational awareness and know where their car is placed to the millimetre.