Are LEGO Technic sets motorized out of the box?

Most are not. The Volvo FMX & EC230 Excavator (42175), for example, is described in YouTube reviews as 'the most expensive non-motorized Technic set,' relying on manual pneumatics rather than a Power Functions motor. Reviewers on r/legotechnic note that motorizing kits via aftermarket Power Functions or Powered Up motors is a popular mod path, but you should expect to buy motors separately for almost every current set.