Not sure what scares you about the FF series, but each entry is generally a completely standalone title. You can generally play them in any order unless you’re trying to “experience the whole series”…and that’s only because there are some games that are basically “Like this older FF, but better!”
FF9 is a great starting point if you can put up with PS1 loading times.