Been there and done that. If I remember Oncor will run power 90 feet from a transformer and tie into the weather head. We were responsible for breaker, meter box, weather head , pole and wiring. I think we spent 500-700 to get it set up.
Yes, a transformer is required anytime power is dropped down from a higher-voltage transmission line.
Some places sell "trailer poles" made ready to go with the weather head, meter base, and breaker box. Some may even include a outlet box.
Pick a day when the 4-6ft ground rod can be driven into the ground with greater ease.
If an existing transformer is nearby, connection charges should be much lower.