Overall, it really depends what is at the other end of that line. I'm not really an amusement park fan - last went to a Six Flags 3 years ago and only because I had a friend with free passes - all of the coaster lines were 1 hour long and I was only willing to make an exception for 1 "old school" wooden roller coaster that I was OK waiting for, neither of us were willing to wait even 15 mins for the others.
On my first visit to Paris, I showed up for the Eiffel Tower 30-40 minutes in advance of it opening, but a whole bunch of other people had done the same so I was unable to get a ticket all the way to the very top level by the time I made it up to the ticket counter. I made it to Level 2 and I was satisfied with that, and had zero desire to go back up again on any subsequent trips as I was content to see it in the distance (like for free from the rooftop terrace of one of the main department stores) or from the lawn or Trocadero if I wanted to be closer for the light show. Now I've hit an age where I don't even want to deal with the zoo that is Trocadero so I seek out restaurants or bars that have a full view of the Eiffel as I really don't care about going up in it, I just want to see it.
For other big sites, I guess I've just always been either lucky or am playing my cards right making sure I have something like a Museum Pass, an advance ticket or reservation booked online, or I'm showing up either prior to opening time or taking advantage of extended visiting hours on certain days. I also completely avoid a place if it's a "free admission" day because that will inevitably be when it's most crowded with the longest lines.
On my first visit, I had a Museum Pass but showed up for Versailles 40 minutes prior to opening. It gave me time to stand around drinking a cafe creme and eating a croissant for breakfast, I got to take photos of the exterior of the palace with hardly any one around to get in the picture, and I secured my spot that got me through the door in one of the very first groups to tour the palace. It worked out fine as by the time I was halfway through exploring the palace, the place was becoming a mob scene. I finished up my tour and was happy to escape to the grounds and visit the gardens closest to the palace, Trianon and Hamlet in relative peace.
Been to the Louvre on many trips, so last visit I went on a day they were open late, found zero people in line and was able to get in immediately. The most crowded part of the museum at that time was the wing where Mona Lisa is kept. But I'd seen it already, so I just headed for Napoleon's Apartments which was almost empty at that time of day. By the time I was wrapping up my evening visit (about 20 minutes before they announced the museum was closing soon), I decided to wander back over towards the Mona Lisa wing and it paid off because instead of having to jockey for position like I did on my first visit just to catch a glimpse of it, I was able to walk straight across the room and stand directly in front of it for several minutes without tons of people taking photos.
Catacombs I think I just must have got lucky even though I visited during peak tourist season. I always see people talking about the many hours it took them to get into the Catacombs and there's no way I ever would have waited more than 30-40 mins. I showed up right after lunch and the wait was minimal, line moved fairly quick, and although it was a little crowded inside the first part once once I was underground, by the time I started walking through the tunnel, there were large parts where I was completely on my own to the point it was even a little creepy.
On first visit, the ticket line for Musee d'Orsay was crazy long, but I used my MuseumPass and went into a separate entrance with no line. Never found any issues with long security lines except for 1x at Conciergerie where it took about 25 mins. Everywhere else it has been very fast.