This photo comes from the M Oakley Collection via a scan from Branch Lines Around Avonmouth, by Vic Mitchell and Keith Smith, ISBN 190447442X. My reproduction quality isn't great, but hopefully you can see Hotwells Station as it was in its early years, including the turntable at the far end, just in front of the stationmaster's house, to the left of the booking office.

Later the turntable was removed and the tracks extended all the way to the end to make the most of the limited platform space; the engine would move onto the centre run-around track in advance, then pull the carriages into the station on the other track using a draw-bar instead of using the turntable to run around them after it had pulled them in.

My favourite tidbit from Colin Maggs' The Bristol Port Railway & Pier is the last bit here:

Around the turn of the century, a stationmaster at Sea Mills kept poultry, pigs, a cow and used his pony and trap to fetch swill from the docks. He sold eggs to passengers and provided the the Superintendent at Bristol with butter and new-laid eggs. Another character was a driver nicknamed ‘Mad Jack’. He enjoyed scaring the dockers to death by rushing through the tunnels into Hotwells, once misjudging his braking power and crashing into the buffers.

Must've been quite unnerving, racing out of the tunnel straight towards the cliff face at speed!