Detection and characterisation of transiting exoplanets with TESS across populations and orbital periods