Welcome to AA! Definitely do the research. You can make the best of either setup.
I always love visiting NewWorld Aquarium when in NY visiting friends. Here is a link. New World Aquarium
They have beautiful fresh and marine fish and some nice plants, if you go fresh and consider a planted tank.
Keep us posted on what you decide
. Happy fish keeping!