I've been learning to take "real" photos with a Sony A6400 over the past few months, with a couple of Sigma prime lenses. I've been super super happy with the photos I've managed to get out of it and definitely recommend a similar setup!
It feels limited for video though — a lot of options but no way to get beyond 8 bits per channel, so iphone hdr videos win in most cases.
I think it depends on what you want - I have managed to get some absolutely fantastic video out of it, especially with the 30mm sigma lens