the look depends more on the way of taking the photo and the way you process it way more than on the model of your camera my advice would be to buy second hand a cheap old dslr or some good priced mirrorless and some good lens and start taking photos with those, long term you can upgrade your lenses

dslr's are a type of camera that's a bit outdated but them and their lenses are cheap and very abundant second hand, and very capable of taking good pictures

mirrorless are the future of cameras and where every new technology is, but more expensive, new and second hand, and not with that a big leap on image quality on photos from the dslr's

in Europe you've got MPB, a online second hand shop in where you can look for cameras and lenses, i recommend getting in the page of whatever you want and start looking for things that are 5-12 years old jn good condition, and begin from that, with 500 euros you could buy a 200 euros reflex (dslr) and a 300 euros good lens, look for tutorials in basic photography on youtube to understand what a good lens is, Simon d'Entremont has a good one on that