@Madeline Burke First off, welcome to the Fort! As you mentioned, we are in a very competitive market right now, but you can still find deals if you are prepared to act quickly! House hacking is a great way to start investing as long as you're OK with having room mates.
Old town in definitely getting expensive, but occasionally there are places that hit the market that fall around your price range. If you're looking for an investment, it might be wise to check the emotions at the door. Make sure your numbers are solid. Learn the local laws for rentals (U+2, noise ordinances, etc).
I've lived in Fort Collins for about 10 years and it's incredible how much it has changed since then. Obviously it is a very desirable place to live (for good reason) which makes it tougher to find what you're looking for. Being a licensed broker, I understand your concern and frustration as I see many people go through the same thing. As an investor, I highly recommend learning what different areas rent for, what property conditions warrant higher rents and what will best fit your needs. Just looking at $/sqft. will not give you the answers you're looking for. Run all of the math to determine if a property is a good investment.
Feel free to PM me if you want to talk more about our local RE market or have any questions about it or the town. I'd be more than happy to share what I know about our awesome slice of CO!